Re: Sequence value (Record Id)

From: "Esa Pikkarainen" <epikkara(at)ktk(dot)oulu(dot)fi>
To: pgsql-general(at)postgresql(dot)org, dynamic(at)inline(dot)net
Subject: Re: Sequence value (Record Id)
Date: 2000-12-15 13:09:00
Message-ID: 2BAEC9A482E@ktk.oulu.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Speegle 2000-12-15 14:07:30 Re: Help!Can't connect Postgresql JDBC driver
Previous Message Alessio Bragadini 2000-12-15 12:32:44 Re: Sequence value