Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Agreed. What is really weird is that the time is always displayed for a
> zero value:
> test=> select interval '0 years' year;
> interval
> ----------
> 00:00:00
> (1 row)
> but a non-zero shows the proper units:
> test=> select interval '1 years' year;
> interval
> ----------
> 1 year
> (1 row)
> Is that OK?
Well, it's a bit arbitrary, but I suppose it was done because otherwise
a zero interval would show nothing at all ...
regards, tom lane