The following bug has been logged on the website:
Bug reference: 14632
Logged by: Pietro Pugni
Email address: pietro(dot)pugni(at)gmail(dot)com
PostgreSQL version: 9.6.2
Operating system: Ubuntu 16.04.2 LTS
Description:
The following query:
SELECT '1912-02-29'::date + '10 years'::interval
returns:
'1922-02-28 00:00:00'
while the reverse operation:
SELECT '1922-02-28'::date - '10 years'::interval
returns:
'1912-02-28 00:00:00'
instead of '1912-02-29 00:00:00'.