On Wed, Apr 20, 2011 at 9:21 PM, Emi Lu <emilu(at)encs(dot)concordia(dot)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::
http://www.postgresonline.com/journal/archives/79-Simulating-Row-Number-in-PostgreSQL-Pre-8.4.html
--Raghu Ram
> Thanks a lot!
> 丁叶
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>