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

From Andrew Gierth
Subject Re: [BUGS] BUG #14632: Plus and minus operators inconsistency with leap years and year intervals.
Date
Msg-id 8760hqur29.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Re: [BUGS] BUG #14632: Plus and minus operators inconsistency with leap years and year intervals.  (Pietro Pugni <pietro.pugni@gmail.com>)
List pgsql-bugs
>>>>> "Pietro" == Pietro Pugni <pietro.pugni@gmail.com> writes:
Pietro> The whole point (for leap years) is:
Pietro>  - inconsistency (adding and subtracting the same quantity to aPietro>  date should provide the date itself,
butit doesn't);
 

It should be obvious that this is mathematically impossible; a function
from a larger set (the 366 days of a leap year) to a smaller one (the
365 days of a common year) cannot have an inverse.

-- 
Andrew (irc:RhodiumToad)


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: [BUGS] Concurrent ALTER SEQUENCE RESTART Regression
Next
From: Roy Brokvam
Date:
Subject: [BUGS] Meaning of pg_constraint.conindid for foreign keys