SERIAL type (look it up in the docs).
Regards,
Aasmund
PS. I may not be good at counting, but I have counted your two words 3 times and I
still get 6.
On Thu, 25 Oct 2001 23:09:32 +0300, Alexey Prohorenko <[EMAIL PROTECTED]> wrote:
> How can I reproduce in PostgreSQL type structure fr
Use SERIAL instead of AUTO_INCREMENT.
> How can I reproduce in PostgreSQL type structure from MySQL:
> INT NOT NULL PRIMARY KEY AUTO_INCREMENT
>
> ?
>
> To be more exact -- in two words: "how can I create autoincrement
> field?"
>
> Thanks a lot.
>
> --
>
How can I reproduce in PostgreSQL type structure from MySQL:
INT NOT NULL PRIMARY KEY AUTO_INCREMENT
?
To be more exact -- in two words: "how can I create autoincrement
field?"
Thanks a lot.
--
green
[http://www.extrasy.net]
--
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
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
