X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 60E5ED1B509
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 15 Nov 2003 16:41:59 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 55428-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 15 Nov 2003 12:41:28 -0400 (AST)
Received: from mwinf0202.wanadoo.fr (smtp2.wanadoo.fr [193.252.22.29])
	by svr1.postgresql.org (Postfix) with ESMTP id 9A9ABD1B51B
	for <pgsql-sql@postgresql.org>; Sat, 15 Nov 2003 12:41:27 -0400 (AST)
Received: from gina (ASte-Genev-Bois-102-1-4-233.w80-11.abo.wanadoo.fr
	[80.11.203.233])
	by mwinf0202.wanadoo.fr (SMTP Server) with ESMTP id 34B66A400137
	for <pgsql-sql@postgresql.org>; Sat, 15 Nov 2003 17:41:26 +0100 (CET)
From: Guillaume LELARGE <gleu@wanadoo.fr>
Organization: traduc.org
To: pgsql-sql@postgresql.org
Subject: Re: Getting last insert value
Date: Sat, 15 Nov 2003 17:41:41 +0000
User-Agent: KMail/1.5.3
References: <Pine.SGI.4.58.0311151003320.76056@guinness.cs.stevens-tech.edu>
	<200311151640.42892.gleu@wanadoo.fr>
In-Reply-To: <200311151640.42892.gleu@wanadoo.fr>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200311151741.41361.gleu@wanadoo.fr>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200311/170
X-Sequence-Number: 15985

Le Samedi 15 Novembre 2003 16:40, vous avez =E9crit :
> 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


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