Re: Autoincremental value
От | Ben |
---|---|
Тема | Re: Autoincremental value |
Дата | |
Msg-id | Pine.LNX.4.44.0408131251170.17735-100000@localhost.localdomain обсуждение исходный текст |
Ответ на | Autoincremental value (adburne@asocmedrosario.com.ar) |
Список | 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 по дате отправления: