From: | "Incorrect result from operator "overlaps"" <wolfmoon(at)o2(dot)pl> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #6192: Incorrect result from operator "overlaps" |
Date: | 2011-09-01 08:27:27 |
Message-ID: | 201109010827.p818RRBg059211@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 6192
Logged by: Incorrect result from operator "overlaps"
Email address: wolfmoon(at)o2(dot)pl
PostgreSQL version: 9.0.4
Operating system: Debian/Sid
Description: Incorrect result from operator "overlaps"
Details:
SELECT ('2011-08-31'::date,'2011-08-31'::date) overlaps
('2011-08-1'::date,'2011-08-31'::date);
Returns false, should return true.
SELECT ('2011-08-31'::date,'2011-08-31'::date) overlaps
('2011-08-1'::date,'2011-09-1'::date);
Returns true, as it should.
SELECT ('2011-08-31'::date,'2011-08-31'::date) overlaps
('2011-08-31'::date,'2011-09-1'::date);
Returns true, as it should.
Tested in versions 8.3.14, 8.4.7 and 9.0.4.
From | Date | Subject | |
---|---|---|---|
Next Message | Valentine Gogichashvili | 2011-09-01 09:48:18 | Re: BUG #6186: out of memory while analyze |
Previous Message | Dave Page | 2011-09-01 08:21:43 | Re: BUG #6191: One click installer fails |