Re: Autoincremental value - Mailing list pgsql-general

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