Received: from home.priority.net (home.priority.net [204.27.108.182])
	by hub.org (8.9.3/8.9.3) with ESMTP id MAA84305
	for <pgsql-sql@postgreSQL.org>; Thu, 21 Oct 1999 12:14:47 -0400 (EDT)
	(envelope-from tpham@mail.priority.net)
Received: by home.priority.net with Internet Mail Service (5.5.2448.0)
	id <VBLNBF3H>; Thu, 21 Oct 1999 11:31:12 -0500
Message-ID: <551413BBBB03D111BF880060B01AACCE139FD0@home.priority.net>
From: "Pham, Thinh" <tpham@mail.priority.net>
To: "'Rodrigo Bernardo Pimentel'" <rbp@pobox.com>, pgsql-sql@postgreSQL.org
Subject: RE: [SQL] auto_increment?
Date: Thu, 21 Oct 1999 11:31:11 -0500
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2448.0)
Content-Type: text/plain;
	charset="windows-1252"

How about using "serial" in the place of "auto_increment"? such as

CREATE TABLE table (
id       serial,
name     text,
email    text);

I guess you already know this but i thought i'd just mention it anyway,
using "table" for table name wouldn't work ;-)
Thinh


> -----Original Message-----
> From: Rodrigo Bernardo Pimentel [mailto:rbp@pobox.com]
> Sent: Thursday, October 21, 1999 10:45 AM
> To: pgsql-sql@postgreSQL.org
> Subject: [SQL] auto_increment?
> 
> 
> 	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@somewhere.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@pobox.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
> 
> ************
>