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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

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?



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-2017 The PostgreSQL Global Development Group