[postgis-tickets] [PostGIS] #5401: ST_Difference silently giving us wrong results

PostGIS trac at osgeo.org
Wed Jun 14 07:44:04 PDT 2023


#5401: ST_Difference silently giving us wrong results
-----------------------+---------------------------
  Reporter:  laopsahl  |      Owner:  pramsey
      Type:  defect    |     Status:  new
  Priority:  medium    |  Milestone:  PostGIS 3.3.4
 Component:  postgis   |    Version:  3.3.x
Resolution:            |   Keywords:
-----------------------+---------------------------
Comment (by laopsahl):

 This code suggested by Sandro seems to work

 {{{

 CREATE TABLE difference_test_01 AS
 SELECT
   ST_Difference(
     a.geo,
     ( SELECT ST_Union(u.geo) FROM used_area u )
   )
 AS geom
 FROM all_area a;

 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5401#comment:7>
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.


More information about the postgis-tickets mailing list