Any function for calculating inersect of intervals?

Поиск
Список
Период
Сортировка
От Együd Csaba
Тема Any function for calculating inersect of intervals?
Дата
Msg-id 0IAG006HCZ4DK8@mail.vnet.hu
обсуждение исходный текст
Ответы Re: Any function for calculating inersect of intervals?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Any function for calculating inersect of intervals?  (Alban Hertroys <alban@magproductions.nl>)
Список 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.


В списке pgsql-general по дате отправления:

Предыдущее
От: Nick Burch
Дата:
Сообщение: Re: What is postgresql doing for "statement: commit;begin;"
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Any function for calculating inersect of intervals?