[postgis-tickets] [PostGIS] #3484: IS DISTINCT FROM not seeing additional points

PostGIS trac at osgeo.org
Tue Mar 1 06:38:12 PST 2016


#3484: IS DISTINCT FROM not seeing additional points
-----------------------+---------------------------
  Reporter:  pvalsecc  |      Owner:  pramsey
      Type:  defect    |     Status:  new
  Priority:  medium    |  Milestone:  PostGIS 2.2.2
 Component:  postgis   |    Version:  2.2.x
Resolution:            |   Keywords:
-----------------------+---------------------------

Comment (by pramsey):

 `DISTINCT ON`, `GROUP BY`, `DISTINCT FROM` keywords all delegate to
 operators from the btree opclass, which since time immemorial in PostGIS
 geometry have been backed by single precision bounding boxes. I'm afraid
 this is not fixable nor are the many other reports we've had over the
 years on this issue. Workaroud: use `NOT ST_Equals(a, b)`

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