Bruce Momjian <pgman@candle.pha.pa.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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
