> hi there,
> i work with postgreSQL 7.0.2, ZPyGreSQL and zope 2.2 on suse 7.0 linux
> for a identifier field adr_id:serial i want to automatically insert a
> new number max(adr_id)+1
> how can this be done in an insert into sql statement?
> i tried nextval('adr_adr_id_seq') but get an error message
> any idea?
http://www.postgresql.org/docs/aw_pgsql_book/node85.html
ff.
cheers,
oliver