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

Bborie Park dustymugs at gmail.com
Mon Jul 23 21:01:18 PDT 2012


Ah.  Thanks for the explanation!

-bborie

On Mon, Jul 23, 2012 at 8:51 PM, Paragon Corporation <lr at pcorp.us> wrote:
> 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
>
>
> _______________________________________________
> 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