AUTOINCREMENT--help

From: "Macky" <macky(at)edsamail(dot)com>
To: "Postgresql-Sql" <pgsql-sql(at)postgresql(dot)org>
Subject: AUTOINCREMENT--help
Date: 2001-01-02 02:23:23
Message-ID: 003701c07462$fb451700$5764a8c0@edsamail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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............

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2001-01-02 02:40:08 Re: [SQL] Removing a constraint?
Previous Message Michael Davis 2001-01-02 00:04:41 Removing a constraint?