Robert Haas <robertmhaas@gmail.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