Re: BUG #1517: SQL interval syntax is accepted by the parser,

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