Because of leap days and their two part nature, there are some aspects of
intervals that should be covered more precisely in the documentation.
Example 1:
area=> select '1999-02-28'::timestamp + '1 day 1 year';
?column?
------------------------
2000-02-29 00:00:00-06
This indicates that the month-year offset of an interval is added before the
day offset. Is this always the case?
Example 2:
area=> select '2000-02-29'::timestamp - '1999-02-28';
?column?
------------
366 +00:00
This suggests that the difference between to timestamps returns an interval
with a 0 year-month part. Is this always the case?
Example 3:
area=> select '2000-02-29'::timestamp + '1 year';
?column?
------------------------
2001-02-28 00:00:00-06
This suggests that when a year-month offset results in a day of February 29
in a now leap year, that February 28 is returned instead. Is this always the
case?
Example 4:
area=> select '1999-03-01 1:00 UTC'::timestamp + '1 year';
?column?
------------------------
2000-02-28 19:00:00-06
This suggests that the year-month offset is applied to the timestamp
represented in local time zone. Is this always the case?