| From: | Marko Tiikkaja <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi> |
|---|---|
| To: | PostgreSQL development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Writeable CTEs |
| Date: | 2010-01-05 16:42:27 |
| Message-ID: | 4B436BF3.1060707@cs.helsinki.fi |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 | Content-Type | Size |
|---|---|---|
| writeable4.patch | text/plain | 60.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2010-01-05 16:48:11 | Re: Testing with concurrent sessions |
| Previous Message | Hiroshi Inoue | 2010-01-05 16:40:14 | Re: krb_server_keyfile setting doesn't work on Windows |