[postgis-users] The operator && is not overlaps operator based on the OGC SF SQL

Darko Androsevic dandrosevic at galdosinc.com
Tue Aug 17 10:24:31 PDT 2004


Hello,

I am new user of the PostGIS and I have just read the PostGIS manual. I
found that in order to use the spatial index one should use the "&&"
operator.
This operator ("&&") is named the "overlap" operator (page 6, page 14 of the
manual).
I am not sure whether this definition is related to the "overlaps" operator
in the OGC Simple Features Specification For SQL or not.
In the OGC doc, the "overlaps" operator is defined only for A/A L/L and P/P
and it is defined like:

a.Overlaps(b)<=>(dim(I(a)) = dim(I(b)) = dim(I(a) ^ I(b))  ^  (a^b != a) ^
(a^b != b)

If that is the case, then the postgis "&&" operator means actually
"intersects" and not "overlaps".
I tried this by executing a few query and found that the operator "&&" might
be an implementation of the "intersect" operator.

I would appreciate some comments and clarifications.

Regards,
Darko




More information about the postgis-users mailing list