| From: | omar(at)tinysofa(dot)org |
|---|---|
| To: | pgsql-patches(at)postgresql(dot)org |
| Subject: | INSERT ... RETURNING |
| Date: | 2005-07-05 03:53:01 |
| Message-ID: | 1120535581.42ca041d40b36@webmail.tinysofa.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
Hi there,
Attached is a patch (by Gavin Sherry, fixed up to apply to 8.1 by me) that
implements INSERT ... RETURNING functionality.
It does work for the common case of RETURNING the value of a serial/sequence
column, but gets confused when returning results out-of-order (CREATE TABLE x
(a int, b int), INSERT ... RETURNING b, a) and doesn't let you specify the same
column multiple times (INSERT ... RETURNING b, b). These will be addressed
soon.
Regards,
Omar Kilani
| Attachment | Content-Type | Size |
|---|---|---|
| insert-returning-6.patch | application/octet-stream | 22.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2005-07-05 07:30:18 | Re: [HACKERS] Dbsize backend integration |
| Previous Message | Tom Lane | 2005-07-05 03:45:04 | Re: silence GCC4 warning |