PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> Consider the following calculations:
AFAICS all of these are behaving as-expected. Yeah, it's confusing,
but expecting calendar calculations to have mathematical rigor is
a fool's errand. The intent of what's implemented is to produce
useful results for calculations like
regression=# SELECT TIMESTAMPTZ '2025-03-30' + INTERVAL '1 day';
?column?
------------------------
2025-03-31 00:00:00+02
(1 row)
despite the intervening DST change.
regards, tom lane