enumerating rows - Mailing list pgsql-sql

From Kovacs Zoltan
Subject enumerating rows
Date
Msg-id Pine.LNX.4.21.0104111357510.3543-100000@pc10.radnoti-szeged.sulinet.hu
Whole thread Raw
Responses Re: enumerating rows
Re: enumerating rows
List pgsql-sql
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
 



pgsql-sql by date:

Previous
From: "Oliver Elphick"
Date:
Subject: Re: Concatenate fields
Next
From: "Poul L. Christiansen"
Date:
Subject: Re: enumerating rows