Autoincremental value

From: adburne(at)asocmedrosario(dot)com(dot)ar
To: pgsql-general(at)postgresql(dot)org
Subject: Autoincremental value
Date: 2004-08-13 16:50:48
Message-ID: 14610181509.20040813135048@asocmedrosario.com.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi I'm a newbie in postgresql, I came from MSSQL, MySQL and now
I'm testing postgres.
In mysql there is a way to make a second autoincrement field, just:

create table table1
(field1 integer,
field2 integer autoincrement,
primary key (field1,field2))

when insert rows:

insert into table1 (field1) values (1);
insert into table1 (field1) values (1);
insert into table1 (field1) values (2);

and then select * from table1, you get:
field1| field2
------+-------
1 | 1
1 | 2
2 | 1
------+-------

there is a way to do this with postgres???

thnx!!!!

--
Saludos,
adburne
mailto:adburne(at)asocmedrosario(dot)com(dot)ar

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shelby Cain 2004-08-13 16:51:55 Re: Postgresql 8.0 beta 1 service issue
Previous Message Bruce Momjian 2004-08-13 16:29:58 Re: Postgresql 8.0 beta 1 service issue