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_@hotmail.com]
Sent: Monday, May 14, 2001 7:02 AM
To: pgsql-sql@postgresql.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@postgresql.org)
