Hi Paul, > On Fri, Jan 15, 2010 at 5:27 PM, Andreas Brandl <[email protected]> > wrote: > > Is it right to say that - from the set of OGC topology/measurement > functions - the following are using the index? > > > > Equals, Intersects, Touches, Crosses, Within, Contains, Overlaps
Thanks for your reply. Does this apply to both positive and negative cases, i.e. is the index used on both ST_Crosses(A, B) = 1 and ST_Crosses(A, B) = 0? > And every query can use an index, by including an index operator (&&) > in the query, so Relate() can take advantage of the index thusly > > select * from thetable where thegeom && theothergeom and > ST_Relate(thegeom, theothergeom, '000000000'); Thanks for pointing this out. Best regards, Andreas _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
