Hello,
El 13/08/2004 10:50 AM, [EMAIL PROTECTED] en su mensaje escribio:
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???
Check the serial data type.
-- Sinceramente, Josué Maldonado.
"Y conoceréis la verdad, y la verdad os hará libres." San Juan 8-32.
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
