Postgres Pro
Downloads
Home   >   mailing lists

Re: Any function for calculating inersect of intervals? - Mailing list pgsql-general

From Alban Hertroys
Subject Re: Any function for calculating inersect of intervals?
Date
Msg-id 41EBEDC2.2070804@magproductions.nl
Whole thread Raw
In response to Re: Any function for calculating inersect of intervals?  (Alban Hertroys <alban@magproductions.nl>)
List pgsql-general
Tree view 
Alban Hertroys wrote:
> SELECT * FROM table WHERE (D1, D2) INTERSECTS (D3, D4);

Ahem... Let's call that "end of the day dementia" or something... Of
course it's called OVERLAPS, not INTERSECTS...

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Any function for calculating inersect of intervals?
Next
From: "Magnus Hagander"
Date:
Subject: Re: Problem with win32 installer for PG 8.0