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