Re: Using results from INSERT ... RETURNING - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Using results from INSERT ... RETURNING
Date
Msg-id 12895.1254676610@sss.pgh.pa.us
Whole thread Raw
In response to Re: Using results from INSERT ... RETURNING  (Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>)
Responses Re: Using results from INSERT ... RETURNING
Re: Using results from INSERT ... RETURNING
List pgsql-hackers
Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi> writes:
> If I understood you correctly, this would imply that you wouldn't be
> able to do for example:

> INSERT INTO foo
> WITH t AS ( DELETE FROM bar RETURNING * )
> SELECT * FROM t;

Um ... forget what I said --- not enough caffeine yet, apparently.

Yeah, rewrite rules are going to be a *serious* stumbling block to
this whole concept.  Maybe we should just punt the project until we
have a clear idea of how to do that.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Using results from INSERT ... RETURNING
Next
From: David Fetter
Date:
Subject: Re: Using results from INSERT ... RETURNING