Re: [HACKERS] [GENERAL] Using results from DELETE ... RETURNING

2009-06-14 Thread David Fetter
On Sun, Jun 14, 2009 at 05:59:58PM +0200, Petr Jelinek wrote: > David Fetter wrote: >> I was discussing this with Andrew Gierth in IRC, who thought that >> putting RETURNING inside the WITH clause would be relatively easy, at >> least for the parser and planner. For the executor, he suggested that

Re: [HACKERS] [GENERAL] Using results from DELETE ... RETURNING

2009-06-14 Thread Petr Jelinek
David Fetter wrote: I was discussing this with Andrew Gierth in IRC, who thought that putting RETURNING inside the WITH clause would be relatively easy, at least for the parser and planner. For the executor, he suggested that one approach might be to make INSERT, UPDATE and DELETE into their own

Re: [HACKERS] [GENERAL] Using results from DELETE ... RETURNING

2009-06-13 Thread David Fetter
On Sun, Jun 07, 2009 at 12:29:56AM -0400, Tom Lane wrote: > David Fetter writes: > > Would it be super-complicated to do this with CTEs for 8.5? They > > seem to have sane properties like getting executed exactly once. > > Hmm, interesting thought. The knock against doing RETURNING as an > ordi