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 [EMAIL PROTECTED]
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
