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.
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 |