Postgres Pro
Downloads
Home   >   mailing lists

placing position numbers on a query output - Mailing list pgsql-novice

From Oliveiros Cristina
Subject placing position numbers on a query output
Date
Msg-id 00a801c77c51$1a177a90$ec5a3d0a@marktestcr.marktest.pt
Whole thread Raw
In response to prepared statements logging  (marcofuics@netscape.net)
Responses Re: placing position numbers on a query output
List pgsql-novice
Tree view
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 by date:

Previous
From: Regi
Date:
Subject: Install question
Next
From: "A. Kretschmer"
Date:
Subject: Re: placing position numbers on a query output