placing position numbers on a query output

Поиск
Список
Период
Сортировка
Искать
От
Oliveiros Cristina
Тема
placing position numbers on a query output
Дата
Msg-id
00a801c77c51$1a177a90$ec5a3d0a@marktestcr.marktest.pt
Список
Дерево обсуждения
prepared statements logging marcofuics@netscape.net
Hello, All,
 
I would like to know if Postgres has a function similar to ROW_NUMBER().
I would like that the output of a query looked something like this
 
     column1   column2
1       x1              x2
2       y1              y2
3       z1              z2
...
 
I suspect that my question has an easy and quick answer, but from my searches I couldn't find it yet :-(
 
Any help deeply appreciate
 
Best,
Oliveiros
В списке pgsql-novice по дате отправления
От: Regi
Дата:
Сообщение: Install question
От: A. Kretschmer
Дата:
FAQ