Re: BUG #2767: Bug in avg(interval)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Steffen Macke" <sdteffen(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2767: Bug in avg(interval)
Date: 2006-11-21 01:54:16
Message-ID: 16591.1164074056@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Steffen Macke" <sdteffen(at)gmail(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jaime Casanova 2006-11-21 01:55:57 Re: BUG #2764: Capital letter in tables or columns not supported
Previous Message Tom Lane 2006-11-21 01:43:29 Re: BUG #2769: "invalid memory alloc request size <n>" on startup