View Single Post

   
  #10 (permalink)  
Old 04-09-2008, 11:19 AM
Kenneth Downs
 
Posts: n/a
Default Re: Return the primary key of a newly inserted row?

John Tregea wrote:

> Greeting again,
>
> I am writing records to postgreSQL from an IDE called revolution. At
> the time I perform the INSERT command I need to retrieve the value of
> the serial_id column from the newly created row.


We have an after-insert trigger that raises it as a notice. NOTICE
SKEY(xxx)


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Reply With Quote