Re: How to realize ROW_NUMBER() in 8.3?

From: Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com>
To: emilu(at)encs(dot)concordia(dot)ca
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to realize ROW_NUMBER() in 8.3?
Date: 2011-04-20 16:06:49
Message-ID: 736186FB-A7FD-4E7B-85C2-576D81D9ED75@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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(dot)kumar(at)enterprisedb(dot)com
Blog:http://vibhork.blogspot.com

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Oliveiros d'Azevedo Cristina 2011-04-20 16:12:05 Re: How to realize ROW_NUMBER() in 8.3?
Previous Message Emi Lu 2011-04-20 15:45:27 How to realize ROW_NUMBER() in 8.3?