Re: Writeable CTEs and empty relations - Mailing list pgsql-hackers

From Marko Tiikkaja
Subject Re: Writeable CTEs and empty relations
Date
Msg-id ca21d184f7fc2b3476e35b1e3e193ae5@cs.helsinki.fi
Whole thread Raw
In response to Re: Writeable CTEs and empty relations  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Writeable CTEs and empty relations
List pgsql-hackers
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.


Regards,
Marko Tiikkaja
Attachment

pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Bug on pg_lesslog
Next
From: Heikki Linnakangas
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Make standby server continuously retry restoring the next WAL