Writeable CTEs
Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>
From: Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>
To: PostgreSQL development <pgsql-hackers@postgresql.org>
Date: 2010-01-05T16:42:27Z
Lists: pgsql-hackers
Attachments
- writeable4.patch (text/plain) patch
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