Re: INSERT ... RETURNING

Here here on this one.

With the deprecation of oids on the horizon insert returning is to be
extremely important. It's use with the uniqueidentifier mod would be really
really helpful.

On a similar note, is anyone working on the ability to have a column default
as the product of a function on another column of the same row. I know this
can be done as a trigger but something like CREATE TABLE abc (name text not
null unique, hash not null default somehashfunc(name)); would be very
convenient, and of course with the ability to get the product back with
insert returning.

Kevin McArthur

----- Original Message -----
From: "Bruce Momjian" <pgman@candle.pha.pa.us>
To: <omar@tinysofa.org>
Cc: <pgsql-patches@postgresql.org>
Sent: Friday, July 29, 2005 7:26 PM
Subject: Re: [PATCHES] INSERT ... RETURNING


>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org
>