AUTO_INCREMENT suggestion

From: "D(dot) Dante Lorenso" <dlorenso(at)afai(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: AUTO_INCREMENT suggestion
Date: 1998-03-05 17:00:12
Message-ID: 01bd4858$2988e040$3a151ecf@redhat.afai.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

To aid those of us that don't want to use sequences, can we add a
feature to 6.4 that allows the use of an AUTO_INCREMENT statement
when defining tables? MySQL does this, and I like it. It resembles
the Autonumber feature in Access as well.

create table tblFirm (
FirmID int PRIMARY KEY AUTO_INCREMENT,
FirmTypeID int,
FirmName varchar(64) NOT NULL,
FirmAlpha char(20) NOT NULL UNIQUE,
FirmURL varchar(64),
FirmEmail varchar(64)
);

Just yet another suggestion.

Dante
.------------------------------------------.-----------------------.
| _ dlorenso(at)afai(dot)com - D. Dante Lorenso | Network Administrator |
| | | ___ _ _ ___ __ _ ___ ___ | |
| | |__ / o \| '_|/ o_\| \ |\_ _\/ o \ | Accounting Firms |
| |____|\___/|_| \___/|_|\_|\___|\___/ | Associated, inc. |
| http://www.afai.com/~dlorenso | http://www.afai.com/ |
'------------------------------------------'-----------------------'

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message D. Dante Lorenso 1998-03-05 19:50:39 PostgreSQL and DBI/DBD...vs Pg.pm
Previous Message Bruce Momjian 1998-03-05 16:58:00 Re: [HACKERS] Re: [QUESTIONS] Problems with running v6.3 on DIGITAL UNIX