BUG #8361: 9.3~beta2-2: Wrong `interval' format with aggregate functions.

The following bug has been logged on the website:

Bug reference:      8361
Logged by:          Jan-Benedict Glaw
Email address:      jbglaw@lug-owl.de
PostgreSQL version: Unsupported/Unknown
Operating system:   Debian unstable/experimental
Description:

Hi!


I just found intervals that are shown with more than 24 hours in the `hours'
field. Their overall shown value matches EXTRACT (expoch from xxxx), but the
printed value looks bogus:


buildmaster=> select avg(lastbuild_same) from test_values ;
          avg
-----------------------
 1 day 26:16:18.678927
(1 row)




Notice the "26" there. It's actually 2 days 2h 16min 18sec.


Short SQL snippet can be found at
http://lug-owl.de/~jbglaw/intervals_not_printed_correctly.sql


Would be nice if somebody would test this with further PostgreSQL versions
and specifically with the most recent development branch.


Thanks,
Jan-Benedict