> I to return a sequential row number beginning at 1?
>
> i.e.
>
> row| timestamp
> ---+----------------------------
> 1 2004-02-01 23:15:00.824-05
> 2 2004-02-01 23:15:01.824-05
> 3 2004-02-01 23:15:02.824-05
> ...
>
> My reason for wanting row numbers is so I can use a 'MOD(row_number,
> n)' to get the nth row from the table.
Doesn't LIMIT and OFFSET do the job?
http://www.postgresql.org/docs/7.3/interactive/queries-limit.html
Bye, Chris.