Postgres Pro
Downloads
Home   >   mailing lists

overlaps() does not work as expected? - Mailing list pgsql-hackers

From Mario Weilguni
Subject overlaps() does not work as expected?
Date
Msg-id 200505271835.32416.mweilguni@sime.com
Whole thread Raw
Responses Re: overlaps() does not work as expected?  (Alvaro Herrera <alvherre@surnet.cl>)
Re: overlaps() does not work as expected?  (Jochem van Dieten <jochemd@gmail.com>)
Re: overlaps() does not work as expected?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
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!

pgsql-hackers by date:

Previous
From: Curt Sampson
Date:
Subject: Re: Multiple-statement Rules Incompatible With Constraints
Next
From: Tom Lane
Date:
Subject: Re: Cost of XLogInsert CRC calculations