Try the serial data type or add "DEFAULT nextval('Invoice_s')" to the
column definition where Invoice_s is the name of a sequence that you have
created.
Hope this helps, Michael
-----Original Message-----
From: Sylte [SMTP:Sylte_(at)hotmail(dot)com]
Sent: Monday, May 14, 2001 7:02 AM
To: pgsql-sql(at)postgresql(dot)org
Subject: Auto incrementing an integer
How do I construct a datatype that autoincrement in postgreSQL?
Thanks
Sylte
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)