Re: Getting last insert value

Le Samedi 15 Novembre 2003 15:18, vous avez écrit :
> Hello,
> I have a table with many fields, and one of the fields is of type serial.
> I will do many inserts, and there will be many repeats of the other fields
> in the table, but, obviously, the serial field will be unique for all the
> rows. How can I get the value of serial field of the last row I inserted.
> I know I can select the maximum value from the serial field, but is there
> a better way, preferably something that takes constant time.
> Thanks,
> Yasir Malik
>
Doing a "select currval() from my_table" after your insert should work.

For more details, see
http://www.postgresql.org/docs/7.3/interactive/functions-sequence.html

--
Guillaume
<!-- http://absfr.tuxfamily.org/
http://pgsql-fr.tuxfamily.org/ -->.