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

overlaps() does not work as expected?

From: Mario Weilguni <mweilguni(at)sime(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: overlaps() does not work as expected?
Date: 2005-05-27 16:35:32
Message-ID: 200505271835.32416.mweilguni@sime.com (view raw or flat)
Thread:
Lists: pgsql-hackers
I've quite some trouble with the overlaps function:
SELECT overlaps('9.6.2005'::date, '9.6.2005'::date, '9.6.2005'::date, 
'9.6.2005'::date);
returns true (these are german timestamps dd.mm.yyyy)

SELECT overlaps('8.6.2005'::date, '9.6.2005'::date, '9.6.2005'::date, 
'9.6.2005'::date); 
returns false

Is this a bug or a (quite strange) feature?

Thanks!

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-05-27 16:49:27
Subject: Re: Cost of XLogInsert CRC calculations
Previous:From: Curt SampsonDate: 2005-05-27 16:27:01
Subject: Re: Multiple-statement Rules Incompatible With Constraints

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