Postgres Pro
Downloads
Home   >   mailing lists

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

From raghu ram
Subject Re: How to realize ROW_NUMBER() in 8.3?
Date
Msg-id BANLkTin4wDLhuQf90THA5jhOM9Yoaa1y7Q@mail.gmail.com
Whole thread Raw
In response to How to realize ROW_NUMBER() in 8.3?  (Emi Lu <emilu@encs.concordia.ca>)
Responses Re: How to realize ROW_NUMBER() in 8.3?
List pgsql-general
Tree view


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::



--Raghu Ram


 
Thanks a lot!
丁叶

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: raghu ram
Date:
Subject: Re: How to uninstall PostgreSQL 8.4 on both Windows XP and Windows 7
Next
From: Jorge Arévalo
Date:
Subject: Re: Join query including two generate_series calls causes big memory growth and crash