From: Vibhor Kumar <vibhor.kumar@enterprisedb.com>
To: emilu@encs.concordia.ca
Cc: pgsql-sql@postgresql.org
Subject: Re: How to realize ROW_NUMBER() in 8.3?
Date: Wed, 20 Apr 2011 21:36:49 +0530
Message-ID: <736186FB-A7FD-4E7B-85C2-576D81D9ED75@enterprisedb.com> (raw)
In-Reply-To: <4DAEFF97.9020608@encs.concordia.ca>
References: <4DAEFF97.9020608@encs.concordia.ca>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: vibhor.kumar@enterprisedb.com, emilu@encs.concordia.ca
Subject: Re: How to realize ROW_NUMBER() in 8.3?
In-Reply-To: <736186FB-A7FD-4E7B-85C2-576D81D9ED75@enterprisedb.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox