[EMAIL PROTECTED] wrote:
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
------+-------
Do you mean:
field1| field2
------+-------
1 | 1
1 | 2
2 | 3
------+-------
You need the serial type.
Mage
--
http://mage.hu
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster