Replacement for Oracle's "ROWNUM" in Postgres - Mailing list pgsql-general

From Csaba Nagy
Subject Replacement for Oracle's "ROWNUM" in Postgres
Date
Msg-id 96D568DD7FAAAD428581F8B3BFD9B0F604DE96@goldmine.ecircle.de
Whole thread Raw
Responses Re: Replacement for Oracle's "ROWNUM" in Postgres
List pgsql-general
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 ?
Of course there is always the possibility to do it in a loop and calculate
the dates in the program, but that sucks.

Thanks,
Csaba.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [pgsql-general] Daily Digest V1 #2891
Next
From: Bruce Momjian
Date:
Subject: Re: trouble caused by change in 7.3 handling of '' in