| 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: | Whole Thread | Raw Message | 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
| 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 |