[postgis-users] Error with ~ and @ operators and GIST indexes?

[David Blasby]

Michael O'Sullivan,

We investigated your problem, and found:

1. documentation is incorrect.  The "correct" definintions are:

        A @ B    --- A inside(contained by) B
        A ~  B   --- A contains B

2.  Non-indexed searches for all version of postgresql (7.1, 7.2, and 
7.3) were correct
3. index searches for postgresql 7.1 and 7.2 were correct.
4. index searches for postgresql 7.3 were INCORRECT.


The current CVS version has the fixes.

The "@" and  "~" operators are quite confusing.

dave