[postgis-tickets] [PostGIS] #2422: geography regression difference ST_DWithin

[PostGIS]

#2422: geography regression difference ST_DWithin
---------------------+------------------------------------------------------
 Reporter:  robe     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  high     |   Milestone:  PostGIS 2.1.0
Component:  postgis  |     Version:  2.1.x        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by robe):

 Well doing this:

 {{{
 SELECT
 id, _ST_DistanceUnCached(geog, st_setsrid(st_makepoint(-71.0636, 42.3584),
 4326)::geography)
 , _ST_DistanceTree(geog, st_setsrid(st_makepoint(-71.0636, 42.3584),
 4326)::geography)
 FROM  face
 WHERE _ST_Expand(geog,1609.344) && st_setsrid(st_makepoint(-71.0636,
 42.3584), 4326)::geography
   AND _ST_DistanceUnCached(geog, st_setsrid(st_makepoint(-71.0636,
 42.3584), 4326)::geography)
  != _ST_DistanceTree(geog, st_setsrid(st_makepoint(-71.0636, 42.3584),
 4326)::geography);

 }}}

 returns 0 records.  Doing a check without ST_Expand is going to take a bit
 longer  since I think they are big geometries and 300,000 of them.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2422#comment:12>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.