Re: Sequence value (Record Id) - Mailing list pgsql-general

From Esa Pikkarainen
Subject Re: Sequence value (Record Id)
Date
Msg-id 2BAEC9A482E@ktk.oulu.fi
Whole thread Raw
In response to Re: Sequence value  (Alessio Bragadini <alessio@albourne.com>)
List pgsql-general
AAAHHH, I DID IT!!!!

That:
SQL="SELECT nextval('koe_pkey_id');
     INSERT INTO koe (id, name) VALUES
     (SELECT currval('koe_pkey_id'), 'uusi');"

Now it returns the correct Serial value of the record it inserts.

Yee, I'm glad now
:-D

Thank you all and have a good weekend!
Esa Pikkarainen

pgsql-general by date:

Previous
From: Alessio Bragadini
Date:
Subject: Re: Sequence value
Next
From: Roger Wernersson
Date:
Subject: Re: Sequence value