Re: Replacement for Oracle's "ROWNUM" in Postgres

On Thu, 2002-12-19 at 10:58, Csaba Nagy wrote:
> This query is setting a date into a column for all the rows, starting with a
> fixed date with 10 minutes intervals.
>
> UPDATE some_table
> SET some_date_column = 'some_literal_date' + (ROWNUM / 144.0);
>
> It is used to initialize a table with data.
> Is there any way to get the same result in Postgres somehow ?

One way:

CREATE SEQUENCE dateseq;

UPDATE some_table
SET some_date_column = 'some_literal_date' +
                       (nextval('dateseq') / 144.0)

DROP SEQUENCE dateseq;

b.g.