Postgres Pro
Downloads
Home   >   mailing lists

Re: How to realize ROW_NUMBER() in 8.3? - Mailing list pgsql-sql

From Vibhor Kumar
Subject Re: How to realize ROW_NUMBER() in 8.3?
Date
Msg-id 736186FB-A7FD-4E7B-85C2-576D81D9ED75@enterprisedb.com
Whole thread Raw
In response to How to realize ROW_NUMBER() in 8.3?  (Emi Lu <emilu@encs.concordia.ca>)
List pgsql-sql
Tree view 
On Apr 20, 2011, at 9:15 PM, Emi Lu wrote:

> 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


Following is a link of deepsz which has a way of implementation of rownum.
http://www.depesz.com/index.php/2007/08/17/rownum-anyone-cumulative-sum-in-one-query/

Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.kumar@enterprisedb.com
Blog:http://vibhork.blogspot.com

pgsql-sql by date:

Previous
From: Emi Lu
Date:
Subject: How to realize ROW_NUMBER() in 8.3?
Next
From: "Oliveiros d'Azevedo Cristina"
Date:
Subject: Re: How to realize ROW_NUMBER() in 8.3?