Am 04.03.2024 13:45 schrieb Francisco Olarte:
Intervals are composed of months, days and seconds, as not every month
has 30 days and not every day has 86400 seconds, so to compare them
you have to normalize them somehow, which can lead to bizarre results.
Ah, I see, thanks for the explanation.
Hi all,
I run the “official” deb package postgresql-16 v. 16.2-1.pgdg120+2 on a
Debian Bookworm system, and observed a confusing behavior in a
calculation with time stamps and intervals.
To reproduce, consider the following trivial example:
create table testtab (t1 timestamp without time
