[postgis-users] functions using index

[Andreas Brandl]

Hi Paul,

> On Fri, Jan 15, 2010 at 5:27 PM, Andreas Brandl <ml at 3.141592654.de>
> 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