Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

Next:From: Valentine GogichashviliDate: 2011-09-01 09:48:18
Subject: Re: BUG #6186: out of memory while analyze
Previous:From: Dave PageDate: 2011-09-01 08:21:43
Subject: Re: BUG #6191: One click installer fails

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group