Any function for calculating inersect of intervals?

From: Együd Csaba <csegyud(at)vnet(dot)hu>
To: pgsql-general(at)postgresql(dot)org
Subject: Any function for calculating inersect of intervals?
Date: 2005-01-17 16:24:49
Message-ID: 0IAG006HCZ4DK8@mail.vnet.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
wondering if exists any functions which aim to calculate intersect of two
intervals.
E.g. I have four dates (D1, D2, D3, D4) and I want to know if (D1,D2)
intersects (D3,D4) or not.

I konw that it can be done by comparing the dates (>=,<=), but I'm wonder if
I can do it simpler and shorter.

Thank you very much.

-- Csaba

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.6.13 - Release Date: 2005.01.16.

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.6.13 - Release Date: 2005.01.16.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nick Burch 2005-01-17 16:25:09 Re: What is postgresql doing for "statement: commit;begin;"
Previous Message Frank D. Engel, Jr. 2005-01-17 16:11:35 Re: Problem with win32 installer for PG 8.0