Re: Sequence value

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