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
