On Sun, Nov 14, 2010 at 08:07:22PM +0200, Marko Tiikkaja wrote: > On 2010-11-14 8:01 PM +0200, I wrote: > >In my opinion, all of these should have the same effect: DELETE all rows > >from "foo". > > Since the example wasn't entirely clear on this one: in my opinion > the DML should also only be executed once. So: > > WITH t AS (INSERT INTO foo VALUES (0) RETURNING *) > SELECT 1 FROM t t1, t t2; > > would only insert one row in any case.
Right :) Cheers, David. -- David Fetter <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
