On 2011-04-20, Emi Lu 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
You definitely want to skim through the SQL Cookbook
(http://www.oreilly.de/catalog/9780596009762/) for this
On Wed, Apr 20, 2011 at 11:51:25AM -0400, Emi Lu 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
Thanks a lot!
丁叶
Your best bet is to upgrade to a modern version of PostgreSQL.
On Thu, Apr 21, 2011 at 9:19 PM, David Fetter da...@fetter.org wrote:
On Wed, Apr 20, 2011 at 11:51:25AM -0400, Emi Lu 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
Thanks a
On Wed, Apr 20, 2011 at 09:27:18PM +0530, raghu ram wrote:
On Wed, Apr 20, 2011 at 9:21 PM, Emi Lu em...@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
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
Thanks a lot!
丁叶
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On Wed, Apr 20, 2011 at 9:21 PM, Emi Lu em...@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::