Re: Writeable CTEs and empty relations
Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>
From: Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>
To: PostgreSQL-development <pgsql-hackers@postgresql.org>
Cc: Robert Haas <robertmhaas@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>
Date: 2010-02-11T17:35:18Z
Lists: pgsql-hackers
Attachments
- with_on_dml2.patch (text/plain) patch
On Thu, 11 Feb 2010 19:28:28 +0200, I wrote: > On Thu, 11 Feb 2010 10:53:22 -0500, Robert Haas <robertmhaas@gmail.com> > wrote: >> On Thu, Feb 11, 2010 at 8:46 AM, Marko Tiikkaja >> <marko.tiikkaja@cs.helsinki.fi> wrote: >>> On 2010-02-11 03:44 +0200, I wrote: >>>> I'm going to have to disappoint a bunch of people and give up. :-( >>> >>> Btw. would it make sense to apply the WITH-on-top-of-DML part of this >>> patch? At least to me, this seems useful because you can write a >>> RECURSIVE SELECT and then use UPDATE .. FROM or DELETE .. USING on that >>> CTE. >> >> Hmm, that's a thought. Can you split out just that part? > > Here's the patch. It's the same as the stuff in writeable CTE patches, but > I added regression tests. Whoops. The reference section in docs still had some traces of writeable CTEs. Updated patch attached. Regards, Marko Tiikkaja