[postgis-devel] [PostGIS] #253: Gist causes wrong result from ~=

[PostGIS]

#253: Gist causes wrong result from ~=
----------------------+-----------------------------------------------------
  Reporter:  nicklas  |       Owner:  pramsey      
      Type:  defect   |      Status:  new          
  Priority:  medium   |   Milestone:  postgis 1.4.1
 Component:  postgis  |     Version:  1.3.X        
Resolution:           |    Keywords:               
----------------------+-----------------------------------------------------
Comment (by robe):

 That sounds about right.  If the planner doesn't use the index you should
 see the behavior you expect whereas when it does -- it will use the bboxes
 from the index to satisfy the WHERE and the geometry from the table to
 satisfy the SELECT.

 not all databases behave this way by the way and PostgreSQL may change
 later to implement covered indexes the way say SQL Server does so that the
 index value may also be used if you mark the answer as not lossy (so it
 never needs to hit the table).  In that case the difference will be
 totally camouflaged and harder to troubleshoot.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/253#comment:29>
PostGIS <http://trac.osgeo.org/postgis/>
PostGIS