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/ |
'------------------------------------------'-----------------------'
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 |