BUG #6192: Incorrect result from operator "overlaps"

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.

Responses

Browse pgsql-bugs by date

  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