Replacement for Oracle's "ROWNUM" in Postgres

Поиск
Список
Период
Сортировка
От Csaba Nagy
Тема Replacement for Oracle's "ROWNUM" in Postgres
Дата
Msg-id 96D568DD7FAAAD428581F8B3BFD9B0F604DE96@goldmine.ecircle.de
обсуждение исходный текст
Ответы Re: Replacement for Oracle's "ROWNUM" in Postgres  (Bill Gribble <grib@linuxdevel.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [pgsql-general] Daily Digest V1 #2891
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: trouble caused by change in 7.3 handling of '' in