Re: INSERT ... RETURNING

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: omar(at)tinysofa(dot)org
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: INSERT ... RETURNING
Date: 2005-07-30 02:26:19
Message-ID: 200507300226.j6U2QJ726901@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches


Are you still working on completing this?

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

omar(at)tinysofa(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

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

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Kevin McArthur 2005-07-30 02:39:36 Re: INSERT ... RETURNING
Previous Message Matt Miller 2005-07-29 22:47:18 Re: PL/pgSQL: SELECT INTO EXACT