Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> More to the point, it's also what 8.3.7 does:
Well, no, because the cases at issue are where an <interval qualifier>
is specified. 8.3 did this:
regression=# select '99 seconds'::interval second;
interval
----------
00:00:39
(1 row)
and even more amusingly,
regression=# select interval '99' minute;
interval
----------
00:01:00
(1 row)
regression=# select interval '99' hour;
interval
----------
00:00:00
(1 row)
It was all pretty broken back then.
regards, tom lane