Re: [HACKERS] getting new serial value of serial insert

hi...

>  create table mytable (id serial, name varchar);
> 
>  -- this returns # of rows inserted, as usual...
>  insert into mytable (name) values ('John');
> 
>  -- this returns serial 'id' of inserted record...
>  insert into mytable (id,name) values (0,'Mary');

hm.. this is very elegant syntactically.. 

however, it would be nice to be able to have returned any number of fields of
any types... (for example, i have a trigger that changes a field in a record
whenever it gets updated/inserted.. it would be nice to get this returned as
well...)

also, if possible, it would be nice to extend this to UPDATE... 

can you think of a way to use this syntax aproach that would meet the needs
above?

>  select id from mytable where oid = $sth->{pg_oid_status}
> 
> Seems a waste to have to do this, but I'm not aware of another way.

*nods* seems quite a few people are running into this.

-- 
Aaron J. Seigo
Sys Admin