Re: Return row after a Insert

In response to Carel Combrink :
> I have a Table that looks something like this:
>
> CREATE TABLE My_Table(
> Entry integer PRIMARY KEY DEFAULT nextval('Number'),
> TimeInsert timestamp DEFAULT current_timestamp,
> Severity ENUM_Severity NOT NULL,
> String varchar(512)
> );
>
> where Number is a SEQUENCE and ENUM_Severity is an ENUM
>
> There are 2 things I want to do.
>
> After an INSERT statement I want to be able to know what was the
> 'Entry' number I just added. I was thinking on creating an AFTER

You can use RETURNING *
http://www.postgresql.org/docs/current/static/sql-insert.html

Or just for the SERIAL currval().

Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99