Thread

RE: [HACKERS] AUTO_INCREMENT suggestion

Michael Meskes <meskes@topsystem.de> — 1998-03-07T13:54:00Z

CREATE SEQUENCE is also what ORACLE does.

Michael
--
Dr. Michael Meskes, Projekt-Manager    | topystem Systemhaus GmbH
meskes@topsystem.de                    | Europark A2, Adenauerstr. 20
meskes@debian.org                      | 52146 Wuerselen
Go SF49ers! Use Debian GNU/Linux!      | Tel: (+49) 2405/4670-44

> ----------
> From: 	Goran Thyni[SMTP:goran@bs1.bildbasen.kiruna.se]
> Sent: 	Freitag, 6. März 1998 11:26
> To: 	D. Dante Lorenso
> Cc: 	pgsql-hackers@postgreSQL.org
> Subject: 	Re: [HACKERS] AUTO_INCREMENT suggestion
> 
> 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.
> 
> 	regards,
> -- 
> ---------------------------------------------
> Göran Thyni, sysadm, JMS Bildbasen, Kiruna
>