RE: Auto incrementing an integer

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)