Strange results with interval types computations

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Strange results with interval types computations
Date: 2001-01-14 16:58:13
Message-ID: 200101141658.f0EGwDt99575@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Laurent HERVE (laurent_herve(at)infonie(dot)fr) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
Strange results with interval types computations

Long Description
Look at those two queries :

ez_money=> select '10/01/2000'::date+'1 month'::interval;
?column?
----------------------
2000-10-31 23:00:00+01
(1 row)

ez_money=> select '09/01/2000'::date+'1 month'::interval;
?column?
----------------------
2000-10-01 00:00:00+02
(1 row)

Strange that 10/01/2000 + 1 month does not give 11/01/2000 !

Sample Code

No file was uploaded with this report

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2001-01-14 17:14:22 Re: Strange results with interval types computations
Previous Message Tom Lane 2001-01-14 16:41:22 Re: Database corruption in RH 6.2/prepackaged PG