[postgis-devel] ST_Disjoint doesn't use an index

Paragon Corporation lr at pcorp.us
Mon Jul 23 20:51:25 PDT 2012


No that wouldn't work because two disjoint geometries can have intersecting
bounding boxes but not intersecting geometries.

In theory it should be the same as Not ST_Intersects(g1,g2) except for the
odd-ball case of invalid geometries

In that case geometries neither intersects nor are disjoint.



-----Original Message-----
From: postgis-devel-bounces at postgis.refractions.net
[mailto:postgis-devel-bounces at postgis.refractions.net] On Behalf Of
dustymugs
Sent: Monday, July 23, 2012 7:21 PM
To: PostGIS Development Discussion
Subject: [postgis-devel] ST_Disjoint doesn't use an index

Looking at St_Disjoint(geometry, geometry), I noticed that the function does
not use an index.  Is there is a reason why?  Based upon the docs describing
disjoint, I'd assume that "SELECT NOT $1 && $2 AND ..." would work...

http://postgis.refractions.net/documentation/manual-svn/ST_Disjoint.html

-bborie
_______________________________________________
postgis-devel mailing list
postgis-devel at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-devel





More information about the postgis-devel mailing list