[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