[postgis-users] GIST indexing behavior

[Dave Blasby]

Randy.Goss at kimley-horn.com wrote:

> Why does the query return a single value on the indexed table?

I looked at the code.  I think the index is using "~" as 'contains' and the
non-index uses the "~" as 'contained' - look in postgis.sql.

The standard postgresql functions say that "~" is 'contains' and '@' is
contained, so we need to switch the definition of the '~' and '@' operators.

You're probably the first person to actually use those operators!

dave