Writeable CTEs - Mailing list pgsql-hackers

From Marko Tiikkaja
Subject Writeable CTEs
Date
Msg-id 4B436BF3.1060707@cs.helsinki.fi
Whole thread Raw
Responses Re: Writeable CTEs  (Greg Stark <gsstark@mit.edu>)
Re: Writeable CTEs  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi,

Attached is a patch where I've taken into account the problems Tom
pointed out in his review [1].  It still needs a bit cleaning up, but
I'm not planning on any big changes.  Any feedback welcome.

One thing I only noticed now is this:

=> select * from foo;
  a
---
  0
(1 row)

=> with t as (delete from foo returning *)
-> insert into bar
-> select * from t;
INSERT 0 2

It correctly reports 2 affected rows (one deleted and one inserted), but
is this the answer we want?  It doesn't seem all that useful to know the
total amount of affected rows.


Regards,
Marko Tiikkaja

[1] http://archives.postgresql.org/pgsql-hackers/2009-11/msg01860.php

Attachment

pgsql-hackers by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: krb_server_keyfile setting doesn't work on Windows
Next
From: "Kevin Grittner"
Date:
Subject: Re: Testing with concurrent sessions