On Thu, Mar 26, 2009 at 8:55 PM, David Fetter <david(at)fetter(dot)org> wrote:
> In PostgreSQL 8.4, you'll be able to do:
>
> SELECT
> row_number() OVER (ORDER BY col1) AS i,
> e.col1,
> e.col2,
> ...
> FROM ...
Good news! Better late than never :)
> Until then, there are some ugly, fragile workarounds with
> generate_series() and/or temp sequences.
That's exactly my impression based on the other replies and searching
for "postgresql rownum" online.
Thanks,
George