[postgis-users] Re: bug in bbox containment operators

[Greg Janée]

David Blasby wrote:
>If this all works, then try removing the index ("DROP INDEX <index name>") 
>from your table and running your query again.
>
>If this gives the correct answer, then its a problem with the RTree 
>implementation.

The above all worked as you suggested.  The original problematic query 
works fine when the index is removed.

>Try this fix:
>
>Modify postgis_gist_72.c, line about 204 that is currently:
>     case RTContainsStrategyNumber:
>       retval = DatumGetBool( DirectFunctionCall2( box_contain, 
> PointerGetDatum(key), PointerGetDatum(query) ) );
>
>change the "box_contain" to "box_contained", recompile, install, create an 
>index on your table, vacuum analyse and re-try your query.
>
>Does that fix it?

Nope.  Tried the above, but we still see the same bad behavior.  8-(
-Greg