Date interval overlaps

From: Ruzsinszky Attila <ruzsinszky(dot)attila(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Date interval overlaps
Date: 2009-08-27 20:56:58
Message-ID: f637dd860908271356o61fe110fpfd75a47cf3df6de@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2009-08-27 21:21:20 Re: Date interval overlaps
Previous Message Tom Lane 2009-08-27 18:18:58 Re: Speeding up 'bulk' delete (and/or seeing what is going on while the delete is being processed)