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

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 (view raw or flat)
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

pgsql-novice by date

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

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