Re: BUG #2093: SUM of timeintervals, no problems in 8.0.3

Björn Sjölenius wrote:

> The result I get;
>  nick |      time
> ------+----------------
>  apa  | 1 day 69:00:00
>
>
> Expected result is what 8.0.3 give me;
>  nick |      time
> ------+----------------
>  apa  | 3 days 21:00:00

Actually this is expected.  8.1 groups hours and days separately,
because there is no way to know if 1 day means 23, 24 or 25 hours (or
even a fractional number like 24.5) in the presence of a daylight-saving
switch event.  So "1 day 69 hours" is actually more correct.

There is a function to convert to the older format:

alvherre=# select justify_hours('1 day 69:00:00');
  justify_hours
-----------------
 3 days 21:00:00
(1 fila)

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support