Re: [SQL] AUTOINCREMENT--help

2001-01-01 Thread Brett W. McCoy
On Tue, 2 Jan 2001, Macky wrote: > Is there a function in SQL that does autoincrementing... http://www.postgresql.org/docs/faq-english.html#4.16.1 and http://www.postgresql.org/users-lounge/docs/7.0/postgres/sql-createsequence.htm will tell you how to do this. -- Brett

[SQL] AUTOINCREMENT--help

2001-01-01 Thread Macky
Is there a function in SQL that does autoincrementing... eg. CREATE TABLE (name varchar(40),num_id int); wherein num_id starts with 0 and then when ever I INSERT another record num_id goes 1 etc Thanks in advance