Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Re: Writeable CTEs and empty relations
On Thu, 11 Feb 2010 19:28:28 +0200, I wrote: > On Thu, 11 Feb 2010 10:53:22 -0500, Robert Haas <robertmhaas(at)gmail(dot)com> > wrote: >> On Thu, Feb 11, 2010 at 8:46 AM, Marko Tiikkaja >> <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)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
Attachment: with_on_dml2.patch
Description: text/plain (14.6 KB)
Description: text/plain (14.6 KB)
In response to
- Re: Writeable CTEs and empty relations at 2010-02-11 17:28:28 from Marko Tiikkaja
Responses
- Re: Writeable CTEs and empty relations at 2010-02-12 04:26:02 from Robert Haas
- Re: Writeable CTEs and empty relations at 2010-02-13 01:06:43 from Tom Lane
pgsql-hackers by date
Next: From: Alexey Klyukin Date: 2010-02-11 17:36:00 Subject: Re: a common place for pl/perlu modules Previous: From: Aidan Van Dyk Date: 2010-02-11 17:31:54 Subject: Re: Re: [COMMITTERS] pgsql: Make standby servercontinuously retry restoring the next WAL