Re: INSERT ... RETURNING

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: INSERT ... RETURNING
Дата
Msg-id 200507300226.j6U2QJ726901@candle.pha.pa.us
обсуждение исходный текст
Ответ на INSERT ... RETURNING  (omar@tinysofa.org)
Ответы Re: INSERT ... RETURNING
Список 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 по дате отправления:

Предыдущее
От: Matt Miller
Дата:
Сообщение: Re: PL/pgSQL: SELECT INTO EXACT
Следующее
От: "Kevin McArthur"
Дата:
Сообщение: Re: INSERT ... RETURNING