Re: enumerating rows
От
Poul L. Christiansen
Тема
Re: enumerating rows
Дата
Msg-id
Pine.GSO.4.21.0104111526560.17444-100000@borg.cs.auc.dk
Ответ на
enumerating rows (Kovacs Zoltan)
Список
Дерево обсуждения
enumerating rows Kovacs Zoltan <kovacsz@pc10.radnoti-szeged.sulinet.hu>
Re: enumerating rows "Poul L. Christiansen" <poulc@cs.auc.dk>
Re: enumerating rows Kovacs Zoltan <kovacsz@pc10.radnoti-szeged.sulinet.hu>
Re: enumerating rows Peter Eisentraut <peter_e@gmx.net>
Use the "serial" column type. create table myTable (row_no serial,column1 varchar(10),column2 varchar(20)); HTH, Poul L. Christiansen On Wed, 11 Apr 2001, Kovacs Zoltan wrote: > Maybe a trivial question, maybe it's foreign from SQL, I'dont know... > How to add a column which stands for the row number in each row of the > result? E.g.: > > row_no | column1 | column2 | ... > -------+---------+---------+ ... > 1 | datum11 | datum12 | ... > 2 | datum21 | datum22 | ... > ... | ... | ... | ... > > I didn't find anything in the docs. > > TIA, Zoltan > > -- > Kov\'acs, Zolt\'an > kovacsz@pc10.radnoti-szeged.sulinet.hu > http://www.math.u-szeged.hu/~kovzol > ftp://pc10.radnoti-szeged.sulinet.hu/home/kovacsz > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl >
В списке pgsql-sql по дате отправления
