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(at)lug-owl(dot)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