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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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