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