Re: Autoincremental value - Mailing list pgsql-general

From Josué Maldonado
Subject Re: Autoincremental value
Date
Msg-id 411D206F.7010701@lamundial.hn
Whole thread Raw
In response to Autoincremental value  (adburne@asocmedrosario.com.ar)
List pgsql-general
Hello,

El 13/08/2004 10:50 AM, adburne@asocmedrosario.com.ar 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.

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Postgresql 8.0 beta 1 service issue
Next
From: Bruno Wolff III
Date:
Subject: Re: Autoincremental value