auto_increment?

From: Rodrigo Bernardo Pimentel <rbp(at)pobox(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: auto_increment?
Date: 1999-10-21 15:44:52
Message-ID: 19991021134452.E25861@pobox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi.
I recently had to port a script from using Postgres to MySQL.
In Postgres, when I have to use a unique id, I create a sequence
and call nextval('sequence') each time I insert a new line in the table.
MySQL doesn't have sequences (as far as the documentation shows).
So I had to look for an alternative. I found an atribute "auto_increment"
which seems pretty interesting. If I do
CREATE TABLE table (
id int4 primary key auto_increment,
name text,
email text);

It automatically assigns the next value when I do
INSERT INTO table (nome, email) values ('My name', 'me(at)somewhere(dot)com');

When I noticed MySQL didn't have sequences, I cursed a lot. When I
found this out, though, I kept wondering if Postgres also had it, but I
couldn't find any mention in the documentation. Does anyone know if something
similar exists? Am I doing thins the hard way? Is there any other way of
automagically getting unique ids?
TIA,

rbp

________________________________________________________________________
Rodrigo Bernardo Pimentel <rbp(at)pobox(dot)com>| GPG KeyID: 81F85A48
LinuxSP <http://www.linuxsp.org.br>| Fingerprint:
AirGeeks <http://www.airgeeks.org>|7E62 9CA2 C95B FC86 B334
_____________ Debian Linux User ______________|203E C011 2E4D 81F8 5A48

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David Rugge 1999-10-21 16:12:26 Re: [SQL] auto_increment?
Previous Message Tom Lane 1999-10-21 13:30:43 Re: [SQL] bad select performance fixed by forbidding hash joins