Re: Getting last insert value

From: Guillaume LELARGE <gleu(at)wanadoo(dot)fr>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Getting last insert value
Date: 2003-11-15 17:41:41
Message-ID: 200311151741.41361.gleu@wanadoo.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Yasir Malik 2003-11-15 17:43:15 Re: Getting last insert value
Previous Message Guillaume LELARGE 2003-11-15 16:40:42 Re: Getting last insert value