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@lerctr.org
> US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
-- 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,
Pennsylvania19073