Re: Return the primary key of a newly inserted row? - Mailing list pgsql-general

From John Tregea
Subject Re: Return the primary key of a newly inserted row?
Date
Msg-id 449A121F.9090806@debraneys.com
Whole thread Raw
In response to Return the primary key of a newly inserted row?  (John Tregea <john@debraneys.com>)
List pgsql-general
Sorry, I just realised this should have gone to the SQL list... (Bloody
Newbie's) :-[

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.
>
> Is it possible to have a specified column value returned after the
> INSERT (rather than the number of rows affected) ?
>
> That would save me doing a SELECT select statement after every INSERT.
>
> Please excuse the terminology if it is not SQL'esque, but I hope you
> know what I am getting at.
>
> Thanks in advance
>
> John Tregea
>

pgsql-general by date:

Previous
From: John Tregea
Date:
Subject: Return the primary key of a newly inserted row?
Next
From: Tim Allen
Date:
Subject: Re: Return the primary key of a newly inserted row?