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

From Tom Lane
Subject Re: BUG #8361: 9.3~beta2-2: Wrong `interval' format with aggregate functions.
Date
Msg-id 11418.1375589330@sss.pgh.pa.us
Whole thread Raw
In response to BUG #8361: 9.3~beta2-2: Wrong `interval' format with aggregate functions.  (jbglaw@lug-owl.de)
List pgsql-bugs
jbglaw@lug-owl.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

pgsql-bugs by date:

Previous
From: jbglaw@lug-owl.de
Date:
Subject: BUG #8361: 9.3~beta2-2: Wrong `interval' format with aggregate functions.
Next
From: mnl.post@gmail.com
Date:
Subject: BUG #8363: checksum verification fails with StackBuilder