Roy Badami <roy(at)gnomon(dot)org(dot)uk> writes:
> test=> select interval '1 hour 1 minute';
> interval
> ----------
> 01:01:00
> (1 row)
> Hmm, I don't think I really like having a seconds field in the output,
> given that the column is by definition only storing data to a
> precision of a minute.
Leaving out the seconds would make the display ambiguous.
regards, tom lane