[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

Reply via email to