Postgres Pro
Downloads
Home   >   mailing lists

Date interval overlaps - Mailing list pgsql-novice

From Ruzsinszky Attila
Subject Date interval overlaps
Date
Msg-id f637dd860908271356o61fe110fpfd75a47cf3df6de@mail.gmail.com
Whole thread Raw
Responses Re: Date interval overlaps  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view 
Hi,

My test query:

select (date '2009-08-23', date '2009-08-31') overlaps (date
'2009-08-31', date '2009-08-31');

I want testing whether a given date is in an interval.
Why did I get false?


TIA,
Ruzsi

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Speeding up 'bulk' delete (and/or seeing what is going on while the delete is being processed)
Next
From: Tom Lane
Date:
Subject: Re: Date interval overlaps