Re: Writeable CTEs and empty relations

Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>

View thread

From: Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>

To: Robert Haas <robertmhaas@gmail.com>

Cc: Tom Lane <tgl@sss.pgh.pa.us>, PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2010-02-11T17:28:28Z

Lists: pgsql-hackers

Attachments

with_on_dml.patch (text/plain) patch

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