View Single Post

   
  #2 (permalink)  
Old 04-17-2008, 09:31 PM
Michael Fuhr
 
Posts: n/a
Default Re: Support for RETURNING xxx INTO yyy for INSERT and UPDATE?

On Tue, Feb 22, 2005 at 10:11:24PM -0800, John Napiorkowski wrote:

> what methods can I use to reliable and efficiently return new
> primary keys from inserts?


See "How do I get the value of a SERIAL insert?" in the FAQ:

http://www.postgresql.org/files/docu...AQ.html#4.11.2

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Reply With Quote