Re: How to realize ROW_NUMBER() in 8.3?

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 and many other
things.

Iirc, it suggested a set of CTEs that were joined together and grew
exponentially to get the sequence of numbers, which where finally joined
to the actual query. Pretty elegant and with tailored solutions for
various RDBMS including Postgres.

--
Robert...