Re: INSERT ... RETURNING - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: INSERT ... RETURNING
Date
Msg-id 200507300226.j6U2QJ726901@candle.pha.pa.us
Whole thread Raw
In response to INSERT ... RETURNING  (omar@tinysofa.org)
Responses Re: INSERT ... RETURNING
List pgsql-patches
Are you still working on completing this?

---------------------------------------------------------------------------

omar@tinysofa.org wrote:
> 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, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-patches by date:

Previous
From: Matt Miller
Date:
Subject: Re: PL/pgSQL: SELECT INTO EXACT
Next
From: "Kevin McArthur"
Date:
Subject: Re: INSERT ... RETURNING