Re: How to realize ROW_NUMBER() in 8.3?

On Wed, Apr 20, 2011 at 09:27:18PM +0530, raghu ram wrote:
> On Wed, Apr 20, 2011 at 9:21 PM, Emi Lu <emilu@encs.concordia.ca> wrote:
>
> > Hello,
> >
> > ROW_NUMBER() is only ready in 8.4. For 8.3, is there a simple way to get
> > row_number
> >
> > select row_number(), col1, col2...
> > FROM   tableName
> >
> >
>
> Below link will demonstrates ROW_NUMBER features in pre Postgresql-8.4::
>
> http://www.postgresonline.com/journal/archives/79-Simulating-Row-Number-in-PostgreSQL-Pre-8.4.html

another approach:

http://www.depesz.com/index.php/2007/08/17/rownum-anyone-cumulative-sum-in-one-query/

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
                                                             http://depesz.com/