From: | Lyubomir Petrov <lpetrov(at)sysmaster(dot)com> |
---|---|
To: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Bug 1500 |
Date: | 2005-03-25 21:22:36 |
Message-ID: | 4244811C.80502@sysmaster.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Steve Crawford wrote:
>>So this bug actually brings the issue of interval to_char()
>>formatting. Opinions?
>>
>>
>
>In digging around I discovered that it appears a decision was made to
>remove to_char(interval) at the 8.1 release but I've been unable to
>find the replacement for this functionality. This alarms me.
>
>Given the messages I've seen regarding to_char(interval), it's clearly
>a function that is used. As an example, in our telephony systems
>there is a column for start_time and for end_time. Billing involves a
>sum(end_time-start_time) for the appropriate project/client/period.
>Naturally, that interval needs to be displayed appropriately.
>
>The most common request I've seen (and it would be very helpful for me
>as well) is the ability to fill the largest displayed time increment
>with all remaining time in the interval.
>
>In other words when the total increment is 7 days, 7 hours, 28
>minutes, 12 seconds the desired output would be 10528 minutes 12
>seconds. Think phone-billing, race times, mission clocks, etc.
>
>So...
>
>1) Is there really a plan to eliminate to_char(interval)?
>
>2) If so, what is the replacement?
>
>3) If there isn't a replacement and it's just scheduled for
>elimination, what harm was to_char(interval) causing to require its
>removal and what's the best way to lobby for its retention and
>improvement?
>
>Cheers,
>Steve
>
>.
>
>
>
Steve,
I am with you on this. The interval functionality is very useful and it
will be bad if it gets eliminated. I believe that the best course of
action is to keep the to_char(interval) but restrict the available
format specifications (the textual representation specificators like
Mon/Months).
Regards,
Lyubomir Petrov
From | Date | Subject | |
---|---|---|---|
Next Message | Lyubomir Petrov | 2005-03-25 21:28:08 | Re: Bug 1500 |
Previous Message | Matthew T. O'Connor | 2005-03-25 21:12:27 | Re: lazy_update_relstats considered harmful (was Re: [PERFORM] |