Rusty Conover <rconover(at)infogears(dot)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?
> 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
In response to
pgsql-hackers by date
|Next:||From: Jim C. Nasby||Date: 2007-02-27 04:43:46|
|Subject: Re: Seeking Google SoC Mentors|
|Previous:||From: Tom Lane||Date: 2007-02-27 04:07:10|
|Subject: Re: [HACKERS] COMMIT NOWAIT Performance Option (patch) |