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 по дате отправления