Re: [HACKERS] AUTO_INCREMENT suggestion

On Fri, 6 Mar 1998, Goran Thyni wrote:

> D. Dante Lorenso wrote:
> >
> > 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.
> >
>
> Informix calls something like this SERIAL type, like:
>
> create table tblFirm (
>      FirmID SERIAL PRIMARY KEY,
>      FirmTypeID int,
>      FirmName varchar(64) NOT NULL,
>      FirmAlpha char(20) NOT NULL UNIQUE,
>      FirmURL varchar(64),
>      FirmEmail varchar(64)
> );
>
> Don't know if that is standrd or extension.
>
> We use "CREATE SEQUENCE" to do this is PgSQL.

    Just like PRIMARY KEY pretty much masks a 'CREATE UNIQUE INDEX',
why not SERIAL/AUTO_INCREMENT masking a "CREATE SEQUENCE"?