Ned Wolpert <ned(dot)wolpert(at)knowledgenet(dot)com> writes:
> 1) Being able to use the RETURNING clause in prepared statements, like this
> "INSERT INTO tableName (key1,...)
> VALUES (value1,...)
> RETURNING primKeyName INTO ?"
> Which is what Oracle provides.
INSERT ... RETURNING was discussed recently, and I think people agreed
it's a good idea, but it got hung up on some unresolved issues about how
it should interact with ON INSERT rules for views. Search the pghackers
mailing list archives for details. At this point I think it's probably
too late to consider it for 7.2, but I'm still open to doing it in 7.3
if we can come up with a bulletproof spec.
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Peter Eisentraut||Date: 2001-08-21 21:14:06|
|Subject: RE: Locale by default?|
|Previous:||From: Mikhail Terekhov||Date: 2001-08-21 20:31:45|
|Subject: Re: [HACKERS] Re: WIN32 errno patch|
pgsql-jdbc by date
|Next:||From: Bruce Momjian||Date: 2001-08-21 20:54:17|
|Subject: Re: Couple of patches for jdbc driver|
|Previous:||From: Mihai Gheorghiu||Date: 2001-08-21 20:12:51|
|Subject: Data types|