Re: Autoincremental value - Mailing list pgsql-general

From Ben
Subject Re: Autoincremental value
Date
Msg-id Pine.LNX.4.44.0408131251170.17735-100000@localhost.localdomain
Whole thread Raw
In response to Autoincremental value  (adburne@asocmedrosario.com.ar)
List pgsql-general
Yep, use the serial datatype. And then use the helpful documention. :)

http://www.postgresql.org/docs/7.4/static/datatype.html#DATATYPE-SERIAL
http://www.postgresql.org/docs/faqs/FAQ.html#4.15.2

On Fri, 13 Aug 2004 adburne@asocmedrosario.com.ar wrote:

> 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???
>
> thnx!!!!
>
> --
> Saludos,
>  adburne
>  mailto:adburne@asocmedrosario.com.ar
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>



pgsql-general by date:

Previous
From: Mage
Date:
Subject: Re: Autoincremental value
Next
From: David Garamond
Date:
Subject: psql wishlist: value completion