[postgis-devel] [PostGIS] #282: Change ~= Operator to be a BBOX Only Test

PostGIS trac at osgeo.org
Wed Nov 4 10:50:34 PST 2009


#282: Change ~= Operator to be a BBOX Only Test
---------------------+------------------------------------------------------
 Reporter:  pramsey  |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  high     |   Milestone:  postgis 2.0.0
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------
 Right now the assumed behavior of ~= is an index-assisted exact equality
 check. As a result, unlike all the other GiST operators, it requires a re-
 check, which means that all our operators end up stuck with a re-check.
 Having no re-check can lead to odd behavior (#253) when combining the
 indexed operator call with an un-indexed operator call (#253). It would be
 better to have all our GiST operators consistently work on bounding boxes
 only. This will be a slight breaking behavior change.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/282>
PostGIS <http://trac.osgeo.org/postgis/>
PostGIS


More information about the postgis-devel mailing list