View Single Post

   
  #2 (permalink)  
Old 04-12-2008, 08:23 AM
Tom Lane
 
Posts: n/a
Default Re: Expanding DELETE/UPDATE returning

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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Reply With Quote