Skip site navigation (1) Skip section navigation (2)

pgsql: Add items: > * Prevent to_char() on interval from returning

From: momjian(at)svr1(dot)postgresql(dot)org (Bruce Momjian)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add items: > * Prevent to_char() on interval from returning
Date: 2005-05-07 04:24:34
Message-ID: 20050507042434.A6B00536A4@svr1.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Add items:

> * Prevent to_char() on interval from returning meaningless values
> 
>   For example, to_char('1 month', 'mon') is meaningless.  Basically,
>   most date-related parameters to to_char() are meaningless for
>   intervals because interval is not anchored to a date.
> 
> * Allow to_char() on interval values to accumulate the highest unit
>   requested
> 
> 	o to_char(INTERVAL '1 hour 5 minutes', 'MI') => 65
> 	o to_char(INTERVAL '43 hours 20 minutes', 'MI' ) => 2600 
> 	o to_char(INTERVAL '43 hours 20 minutes', 'WK:DD:HR:MI') => 0:1:19:20
> 	o to_char(INTERVAL '3 years 5 months','MM') => 41
> 
>   Some special format flag would be required to request such
>   accumulation.  Such functionality could also be added to EXTRACT. 
>   Prevent accumulation that crosses the month/day boundary because of
>   the uneven number of days in a month.
>

Modified Files:
--------------
    pgsql/doc:
        TODO (r1.1519 -> r1.1520)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1519&r2=1.1520)
    pgsql/doc/src/FAQ:
        TODO.html (r1.26 -> r1.27)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/TODO.html.diff?r1=1.26&r2=1.27)

pgsql-committers by date

Next:From: Bruce MomjianDate: 2005-05-07 04:38:08
Subject: pgsql: Done: > o -Allow COPY to optionally include column headings in
Previous:From: Bruce MomjianDate: 2005-05-07 02:22:50
Subject: pgsql: Add COPY WITH CVS HEADER to allow a heading line as the first

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group