Re: [SQL] Auto incrementing an integer

2001-05-15 Thread Thomas Swan
Sylte wrote: >How do I construct a datatype that autoincrement in postgreSQL? > Use the SERIAL data type instead of an INT4.Serial is an integer (INT4) that's default value is base on a sequence. for example... create table foo ( my_id serial not null, my_data text ); ---

[SQL] Auto incrementing an integer

2001-05-14 Thread Sylte
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 [EMAIL PROTECTED])