INSERT ... RETURNING - Mailing list pgsql-patches

From omar@tinysofa.org
Subject INSERT ... RETURNING
Date
Msg-id 1120535581.42ca041d40b36@webmail.tinysofa.org
Whole thread Raw
Responses Re: INSERT ... RETURNING
Re: INSERT ... RETURNING
List 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

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: silence GCC4 warning
Next
From: "Dave Page"
Date:
Subject: Re: [HACKERS] Dbsize backend integration