On Fri, Feb 25, 2011 at 10:12:02PM -0500, Tom Lane wrote: > David Fetter <da...@fetter.org> writes: > > What's the effect, if any, on CTEs that depend on each other > > explicitly? > > An error. That would require mutual recursion, which we don't > support for the SELECT case let alone data-modifying statements.
Sorry that was unclear. Let's imagine there's a DELETE ... RETURNING in one WITH, and an UPDATE in another that depends on that one. Is that still allowed? 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 (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers