"Steffen Macke" <sdteffen@gmail.com> writes:
> select avg(test) from problem
> returns
> 1 day 25:15:30
> while the correct result is
> 2 days 01:15:30
This is not a bug; it's the result you're supposed to get.
But see justify_hours() if you want to fold up 24 hours to 1 day.
regards, tom lane