Postgres Pro
Downloads
Home   >   mailing lists

Re: Getting last insert value - Mailing list pgsql-sql

From Guillaume LELARGE
Subject Re: Getting last insert value
Date
Msg-id 200311151741.41361.gleu@wanadoo.fr
Whole thread Raw
In response to Re: Getting last insert value  (Guillaume LELARGE <gleu@wanadoo.fr>)
Responses Re: Getting last insert value  (Yasir Malik <ymalik@heineken.cs.stevens-tech.edu>)
List pgsql-sql
Tree view 
Le Samedi 15 Novembre 2003 16:40, vous avez écrit :
> Doing a "select currval() from my_table" after your insert should work.
>
Actually, this is   select currval('my_sequence')
Sorry about this.

> 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/ -->.

pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Programatically switching database
Next
From: Greg Stark
Date:
Subject: Re: Getting last insert value