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

Tom Lane wrote:
> Roy Badami <roy@gnomon.org.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.

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?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073