Re: wCTE behaviour
David Fetter <david@fetter.org>
From: David Fetter <david@fetter.org>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>, PostgreSQL-development <pgsql-hackers@postgresql.org>, Robert Haas <robertmhaas@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, Yeb Havinga <yebhavinga@gmail.com>, Hitoshi Harada <umi.tanuki@gmail.com>
Date: 2010-12-21T21:20:00Z
Lists: pgsql-hackers
On Tue, Dec 21, 2010 at 11:14:31PM +0200, Peter Eisentraut wrote: > On sön, 2010-11-14 at 04:45 +0200, Marko Tiikkaja wrote: > > On 2010-11-12 8:25 PM +0200, I wrote: > > > I'm going to take some time off this weekend to get a patch with this > > > behaviour to the next commitfest. > > > > .. and a wild patch appears. > > > > This is almost exactly the patch from 2010-02 without > > CommandCounterIncrement()s. It's still a bit rough around the edges and > > needs some more comments, but I'm posting it here anyway. > > To pick up an earlier thread again, has any serious thought been given > to adapting the SQL2001/DB2 syntax instead of our own? Yes, and it's a good deal more limited and less intuitive than ours. This is one place where we got it right and the standard just got pushed into doing whatever IBM did. Cheers, David. -- David Fetter <david@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@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