From: Guillaume LELARGE <gleu@wanadoo.fr>
To: Yasir Malik <ymalik@cs.stevens-tech.edu>
Cc: pgsql-sql@postgresql.org
Subject: Re: Getting last insert value
Date: Sat, 15 Nov 2003 16:40:42 +0000
Message-ID: <200311151640.42892.gleu@wanadoo.fr> (raw)
In-Reply-To: <Pine.SGI.4.58.0311151003320.76056@guinness.cs.stevens-tech.edu>
References: <Pine.SGI.4.58.0311151003320.76056@guinness.cs.stevens-tech.edu>
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/ -->.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gleu@wanadoo.fr, ymalik@cs.stevens-tech.edu
Subject: Re: Getting last insert value
In-Reply-To: <200311151640.42892.gleu@wanadoo.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox