Re: BUG #14632: Plus and minus operators inconsistency with leap years and year intervals.

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14632: Plus and minus operators inconsistency with leap years and year intervals.
Date: 2017-04-26 20:53:10
Message-ID: 5f3b0581-8c2d-8323-73c7-e917da54c96c@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 4/26/2017 1:30 PM, Pietro Pugni wrote:
> Adding 10 years to 1912-02-29 returns 1922-02-29, as expected.
> I would like to apply the *reverse* operation. To do so, I subtract 10
> years from 1922-02-29 but I obtain 1912-02-28, so *the math is
> actually wrong*.

assuming 1922 was a leap year, 1912 is NOT a leap year, so therefore
there is no 1912-02-29, that is an invalid date.

--
john r pierce, recycling bits in santa cruz

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2017-04-26 20:56:20 Re: BUG #14632: Plus and minus operators inconsistency with leap years and year intervals.
Previous Message Pietro Pugni 2017-04-26 20:30:50 Re: BUG #14632: Plus and minus operators inconsistency with leap years and year intervals.