Re: [GENERAL] Sequence value

2000-12-15 Thread Esa Pikkarainen
mean something like: SELECT nextval('koe_pkey_id') as val, (INSERT INTO koe (id, name) values (val, 'uusi')) as dummy FROM koe;" That would both insert new record and return serial value - if it just worked... Thanks Esa Alessio Bragadini wrote (15 Dec 00,): Esa Pikkarainen wrote:

[GENERAL] Sequence value

2000-12-14 Thread Esa Pikkarainen
); SELECT currval('koe_pkey_id') as val;" It causes no error, but I cannot retrieve the value because the queries seem not return any recordsets (nothig can be fetched). Any hints are valuable! Thanks Esa Pikkarainen