6 Dec
2000
6 Dec
'00
7:17 p.m.
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? olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Zanger Nusch Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:info@soli-con.com mailto:olaf.zanger@soli-con.com http://www.soli-con.com