Andreas Kretschmer replied:
> I wrote:
> > How about doing:
> >
> > SELECT justify_interval(90061 * '1 second'::INTERVAL);
>
> Nice, didn't know this function.
Yup, PG does everything! Not sure when I discovered it; also not sure
if I've ever had to use it in anger before. I am, however, slightly
embarrassed that I used the ugly form of interval literals, it looks
prettier to me as:
SELECT justify_interval(90061 * INTERVAL '1 second');
Ah well!
Sam