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@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