Postgres Pro
Downloads
Home   >   mailing lists

Re: Strange results with interval types computations - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Strange results with interval types computations
Date
Msg-id 26379.979492462@sss.pgh.pa.us
Whole thread Raw
In response to Strange results with interval types computations  (pgsql-bugs@postgresql.org)
List pgsql-bugs
Tree view 
pgsql-bugs@postgresql.org writes:
> ez_money=> select '10/01/2000'::date+'1 month'::interval;
> ?column?
> ----------------------
> 2000-10-31 23:00:00+01
> (1 row)

DST transition problem.  It's fixed in current sources.

            regards, tom lane

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Strange results with interval types computations
Next
From: "Michael Richards"
Date:
Subject: Re: Bug in SQL functions that use a NULL parameter directly