Pietro Pugni wrote, On 2017-04-28 10:28:
> I’m aware that 2. and 4. can’t return different result because they are the same queries, but in that cases the result correctness depends on the context.
You can use 10*interval '31556952 seconds' to add or subtract 10 years with consistent results. 31556952 seconds is the average length of the year in the Gregorian calendar. To use this approach, you need to start using timestamp instead of date, and avoid using timestamp with time zone on a time zone that uses daylight savings.
I don't think PostgreSQL needs to do anything about this issue.