Re: No Documentation for to_char(INTERVAL, mask)

Karel,

> The 'interval' version of to_char() isn't implemented -- may be in 7.2
> (it's high in my TODO list:-)

Grazie. (One of the things I love about PostgreSQL is being able to
get definitive answers on functionality -- try asking Microsoft an "is
this implemented?" question!)

Given the lack of to_char(interval), I'd like to write a PLPGSQL
function to fill the gap in the meantime. If you can answer a few
questions about how interval values work, it would be immensely helpful:

1. Hours, minutes, and seconds are displayed as "00:00:00". Days are
displayed as "0 00:00:00". How are weeks, months, and years displayed?

2. If months have their own placeholder in the Interval data type, how
many days make up a month? Is it a fixed value, or does it depend on
the calendar?

Thanks. I'll post the PLPGSQL function to the list after I write it.

-Josh Berkus
--
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco