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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jbglaw(at)lug-owl(dot)de
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8361: 9.3~beta2-2: Wrong `interval' format with aggregate functions.
Date: 2013-08-04 04:08:50
Message-ID: 11418.1375589330@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

jbglaw(at)lug-owl(dot)de writes:
> I just found intervals that are shown with more than 24 hours in the `hours'
> field.

This is not erroneous. "24 hours" is not necessarily equivalent to "1
day", so the interval type doesn't automatically transpose one to the
other. If you want that sort of conversion, see the justify_days(),
justify_hours(), and justify_interval() functions.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message kd_sargent 2013-08-04 09:03:47 BUG #8362: postres webserver
Previous Message jbglaw 2013-08-04 02:00:42 BUG #8361: 9.3~beta2-2: Wrong `interval' format with aggregate functions.