Postgres Pro
Downloads
Home   >   mailing lists

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

From Emi Lu
Subject How to realize ROW_NUMBER() in 8.3?
Date
Msg-id 4DAF00FD.3040301@encs.concordia.ca
Whole thread Raw
Responses Re: How to realize ROW_NUMBER() in 8.3?
Re: How to realize ROW_NUMBER() in 8.3?
Re: How to realize ROW_NUMBER() in 8.3?
List pgsql-general
Tree view 
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!
丁叶

pgsql-general by date:

Previous
From: tv@fuzzy.cz
Date:
Subject: Re: Join query including two generate_series calls causes big memory growth and crash
Next
From: Jorge Arévalo
Date:
Subject: Re: Join query including two generate_series calls causes big memory growth and crash