BUG #11031: Unexpected interval representations

From: marius(dot)bauer(at)here(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #11031: Unexpected interval representations
Date: 2014-07-24 13:23:03
Message-ID: 20140724132303.32098.66956@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 11031
Logged by: Marius Bauer
Email address: marius(dot)bauer(at)here(dot)com
PostgreSQL version: 9.3.3
Operating system: Amazon RDS
Description:

Please see following query and result:

unitystg=> select a + b as sum, b - a as dif, 2 * a as pro, b / 2 as quo
from (select interval'1 day 15:45:25' as a, interval'2 days 12:34:56' as b)
as foo;
sum | dif | pro | quo
-----------------+-----------------+-----------------+----------------
3 days 28:20:21 | 1 day -03:10:29 | 2 days 31:30:50 | 1 day 06:17:28
(1 row)

Usually I'd expect the day will be adjusted in those cases when the hour is
>= 24 or < 0, but this does not happen.

The interval value itself is correct, just the representation is unexpected.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G Johnston 2014-07-24 14:49:37 Re: BUG #11031: Unexpected interval representations
Previous Message Asif Naeem 2014-07-24 07:59:17 Re: [BUGS] BUG #9652: inet types don't support min/max