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: <[EMAIL PROTECTED]>
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?
---------------------------------------------------------------------------
[EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
