Thak you Alban, Tom's solution (OVERLAPS) is the best for me. bye, -- Csaba -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Alban Hertroys Sent: Monday, January 17, 2005 5:49 PM To: Együd Csaba Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Any function for calculating inersect of intervals? Együd Csaba wrote: > 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. Try INTERSECTS :P SELECT * FROM table WHERE (D1, D2) INTERSECTS (D3, D4); Related, are there any operators/functions to test for adjacency (start of one is end of other), inclusion (interval is inside other interval) or wrapping (the inverse; interval is around other interval) of intervals? Alban. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings -- No virus found in this incoming 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 incoming 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. -- 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. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
