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
[EMAIL PROTECTED]
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