Bruno Wolff III <[EMAIL PROTECTED]> writes: > There is a built in type for line segments that uses floating point. That > will probably be usable by you directly unless the integers can can large > enough that precision is a problem. There is an overlaps operator for the > geometric types that could be used to answer your sample questions.
However, there's no built-in rtree opclass for that datatype, so he'd still be stuck with respect to getting indexing support for overlaps queries. I think the contrib/seg datatype might help, though the precision issue is still a possible problem. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings