Re: Sequence value - Mailing list pgsql-general

From Alessio Bragadini
Subject Re: Sequence value
Date
Msg-id 3A39E918.ECFB72BC@albourne.com
Whole thread Raw
In response to Sequence value  ("Esa Pikkarainen" <epikkara@ktk.oulu.fi>)
Responses Re: Sequence value
List pgsql-general
Esa Pikkarainen wrote:

> SQL ="SELECT nextval('koe_pkey_id') as val;
>       INSERT INTO koe (id, name) values (val, 'uusi');"

INSERT INTO koe (id, name) (SELECT nextval('koe_pkey_id'), 'uusi');

--
Alessio F. Bragadini        alessio@albourne.com
APL Financial Services        http://village.albourne.com
Nicosia, Cyprus             phone: +357-2-755750

"It is more complicated than you think"
        -- The Eighth Networking Truth from RFC 1925

pgsql-general by date:

Previous
From: Joost Kraaijeveld
Date:
Subject: RE: Working under NT
Next
From: "Esa Pikkarainen"
Date:
Subject: Re: Sequence value