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