[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] GIST indexing behavior
From:       Dave Blasby <dblasby () refractions ! net>
Date:       2002-05-24 16:37:13
Message-ID: 3CEE6C39.12DA4072 () refractions ! net
[Download RAW message or body]

Randy.Goss@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



[prev in list] [next in list] [prev in thread] [next in thread]