[postgis-tickets] [PostGIS] #2229: [raster] Instability with st_intersection/st_intersects

[PostGIS]

#2229: [raster] Instability with st_intersection/st_intersects
--------------------+-------------------------------------------------------
 Reporter:  kib     |       Owner:  dustymugs
     Type:  defect  |      Status:  new      
 Priority:  high    |   Milestone:           
Component:  raster  |     Version:  2.0.x    
 Keywords:          |  
--------------------+-------------------------------------------------------

Comment(by dustymugs):

 > > Be more specific instead of just "order by lon, lat" since there are
 two of each.  ORDER BY bar.lon, bar.lat.
 > Makes no difference - just tried:-(

 I'm betting this has something to do with floating point issues.  Try
 something like

 ORDER BY round(bar.lon::numeric(16,12), bar.lat::numeric(16,12))

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2229#comment:15>
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.