Re: How to retrieve the serial number of an INSERT?

I don't have a quick answer, but found

at http://www.postgresql.org/docs/aw_pgsql_book/aw_pgsql_book.sql
something,
so try playing around with these

CREATE SEQUENCE functest_seq;

SELECT nextval('functest_seq');

SELECT nextval('functest_seq');

SELECT currval('functest_seq');

SELECT setval('functest_seq', 100);

SELECT nextval('functest_seq');

CREATE SEQUENCE customer_seq;

you could put these in a pl function, and return the value, after doing the insert?

these are different AFAIK from serial datatypes, sequences are


http://www.faqs.org/docs/ppbook/x2632.htm#USINGTHESERIALDATATYPEA


On Tue, Apr 27, 2004 at 10:09:26PM -0400, Daniel Whelan wrote:
> I have the following scenario, and I'm sure many others have wished to do
> something similar. I perform an insert into a table where one field is a
> SERIAL. I wish to perform several other inserts (on other tables) that will
> reference the first record based on its SERIAL field. In the application, I
> wish to name a file based on the SERIAL (I don't wish for postgres to name
> the file for me, I would just like to get at the number).
>
> The specific table is listed below. To recap, I wish to perform an insert
> and also receive the 'id' field value back. Is there any way for me to do
> this, or is there a better technique for achieving what I wish to do?
> Thanks!
>
> Daniel
>
> CREATE TABLE photos (
>    id serial NOT NULL,
>    parent_id integer NOT NULL,
>    photographer_id integer NOT NULL,
>    title character varying,
>    description character varying
> );
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>               http://archives.postgresql.org

--
joe speigle
www.sirfsup.com