On Thu, Mar 26, 2009 at 8:55 PM, David Fetter <david@xxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
