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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Marko Tiikkaja <marko(at)joh(dot)to>
Cc: Pietro Pugni <pietro(dot)pugni(at)gmail(dot)com>, Pg Bugs <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 21:25:57
Message-ID: CAKFQuwYifGfxMyb7=vdJ4iqGM-xZ8COvK_rUv2=4GCQJSHqG0g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, Apr 26, 2017 at 2:06 PM, Marko Tiikkaja <marko(at)joh(dot)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.​

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Pietro Pugni 2017-04-26 22:44:40 Re: BUG #14632: Plus and minus operators inconsistency with leap years and year intervals.
Previous Message Tom Lane 2017-04-26 21:25:18 Re: BUG #14632: Plus and minus operators inconsistency with leap years and year intervals.