| From: | Michael Davis <mdavis(at)sevainc(dot)com> |
|---|---|
| To: | "'Sylte'" <Sylte_(at)hotmail(dot)com>, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | RE: Auto incrementing an integer |
| Date: | 2001-05-15 01:33:06 |
| Message-ID: | 01C0DCAC.B3BB8330.mdavis@sevainc.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guru Prasad | 2001-05-15 08:08:17 | How NULL is interpreted in Pgsql |
| Previous Message | Sylte | 2001-05-14 21:55:51 | Re: Auto incrementing an integer |