Re: Any function for calculating inersect of intervals?

From: Alban Hertroys <alban(at)magproductions(dot)nl>
To: Alban Hertroys <alban(at)magproductions(dot)nl>
Cc: Együd Csaba <csegyud(at)vnet(dot)hu>, pgsql-general(at)postgresql(dot)org
Subject: Re: Any function for calculating inersect of intervals?
Date: 2005-01-17 16:54:26
Message-ID: 41EBEDC2.2070804@magproductions.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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...

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2005-01-17 16:56:08 Re: Problem with win32 installer for PG 8.0
Previous Message Alban Hertroys 2005-01-17 16:48:38 Re: Any function for calculating inersect of intervals?