AUTO_INCREMENT suggestion - Mailing list pgsql-hackers

From D. Dante Lorenso
Subject AUTO_INCREMENT suggestion
Date
Msg-id 01bd4858$2988e040$3a151ecf@redhat.afai.com
Whole thread Raw
List 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@afai.com - D. Dante Lorenso  | Network Administrator |
| | |    ___  _ _  ___  __ _  ___  ___     |                       |
| | |__ / o \| '_|/ o_\|  \ |\_ _\/ o \    | Accounting Firms      |
| |____|\___/|_|  \___/|_|\_|\___|\___/    | Associated, inc.      |
| http://www.afai.com/~dlorenso            | http://www.afai.com/  |
'------------------------------------------'-----------------------'


pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Ouch...
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Re: [QUESTIONS] Problems with running v6.3 on DIGITAL UNIX