Re: interval's and printing...

Add to TODO:

* Have SELECT '13 minutes'::interval display zero seconds

---------------------------------------------------------------------------

Larry Rosenman wrote:
> Why does the interval type not print seconds when they are zero?
>
> This leads to inconsistent reading of the information.
>
> 7.3.3:
>
> ler=# select '13 minutes'::interval;
> interval
> ----------
> 00:13
> (1 row)
>
> ler=# select '13 minutes 1 second'::interval;
> interval
> ----------
> 00:13:01
> (1 row)
>
> ler=#
>
> I noticed this when I loaded the data from my long distance company into
> a PG database.
>
>
> --
> Larry Rosenman http://www.lerctr.org/~ler
> Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
> US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

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