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.