Re: [BUGS] BUG #14632: Plus and minus operators inconsistency withleap years and year intervals. - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: [BUGS] BUG #14632: Plus and minus operators inconsistency withleap years and year intervals.
Date
Msg-id CAKFQuwYifGfxMyb7=vdJ4iqGM-xZ8COvK_rUv2=4GCQJSHqG0g@mail.gmail.com
Whole thread Raw
In response to Re: [BUGS] BUG #14632: Plus and minus operators inconsistency withleap years and year intervals.  (Marko Tiikkaja <marko@joh.to>)
List pgsql-bugs
On Wed, Apr 26, 2017 at 2:06 PM, Marko Tiikkaja <marko@joh.to> wrote:
The problem is that after the subtraction the date '1912-02-28' doesn't know it's supposed to be the last date of the month instead of the 28th, specifically.

Quite true.  It would be nice to have better support for "Month End" (and month start too but that's easier since its always "1") specification but that isn't what we've got.

David J.​

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #14632: Plus and minus operators inconsistency with leap years and year intervals.
Next
From: Pietro Pugni
Date:
Subject: Re: [BUGS] BUG #14632: Plus and minus operators inconsistency with leap years and year intervals.