From: | "Meskes, Michael" <meskes(at)topsystem(dot)de> |
---|---|
To: | "D(dot) Dante Lorenso" <dlorenso(at)afai(dot)com>, Goran Thyni <goran(at)bs1(dot)bildbasen(dot)kiruna(dot)se> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | RE: [HACKERS] AUTO_INCREMENT suggestion |
Date: | 1998-03-07 13:54:00 |
Message-ID: | 11720CEF3853D011AC0C00A024B7A9E110A169@einstein.topsystem.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
CREATE SEQUENCE is also what ORACLE does.
Michael
--
Dr. Michael Meskes, Projekt-Manager | topystem Systemhaus GmbH
meskes(at)topsystem(dot)de | Europark A2, Adenauerstr. 20
meskes(at)debian(dot)org | 52146 Wuerselen
Go SF49ers! Use Debian GNU/Linux! | Tel: (+49) 2405/4670-44
> ----------
> From: Goran Thyni[SMTP:goran(at)bs1(dot)bildbasen(dot)kiruna(dot)se]
> Sent: Freitag, 6. März 1998 11:26
> To: D. Dante Lorenso
> Cc: pgsql-hackers(at)postgreSQL(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Patrick Scott Pierce | 1998-03-07 14:33:47 | Re: [QUESTIONS] Error: ComputeDataSize |
Previous Message | Hannu Krosing | 1998-03-07 13:34:57 | PREPARE statement (was Speedups) |