adburne@asocmedrosario.com.ar 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