Re: Expanding DELETE/UPDATE returning

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Rusty Conover <rconover@infogears.com>
Cc: pgsql-hackers@postgresql.org
Date: 2007-02-27T04:14:01Z
Lists: pgsql-hackers
Rusty Conover <rconover@infogears.com> writes:
> I didn't see this on the TODO list, but if it is my apologies.  Is it  
> in the cards to expand the functionality of DELETE/UPDATE returning  
> to be able to sort the output of the rows returned?

No.

> Or allow delete  
> and update to be used in sub-queries?

That's been discussed but the implementation effort seems far from
trivial.  One big problem is that a sub-query can normally be
re-executed multiple times, eg on the inner side of a join; whereas
that's clearly not acceptable for an insert/update/delete.

			regards, tom lane