| From: | raghu ram <raghuchennuru(at)gmail(dot)com> |
|---|---|
| To: | emilu(at)encs(dot)concordia(dot)ca |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to realize ROW_NUMBER() in 8.3? |
| Date: | 2011-04-20 15:57:18 |
| Message-ID: | BANLkTin4wDLhuQf90THA5jhOM9Yoaa1y7Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jorge Arévalo | 2011-04-20 15:57:19 | Re: Join query including two generate_series calls causes big memory growth and crash |
| Previous Message | raghu ram | 2011-04-20 15:52:09 | Re: [GENERAL] How to uninstall PostgreSQL 8.4 on both Windows XP and Windows 7 |