Re: [GENERAL] Sequence value

[Alessio Bragadini]

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            [EMAIL PROTECTED]
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