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