[postgis-tickets] [PostGIS] #3521: Wrong result of <select distinct geometry from XXX>

[PostGIS]

#3521: Wrong result of <select distinct geometry from XXX>
--------------------------+---------------------------
  Reporter:  yuanrui1987  |      Owner:  pramsey
      Type:  defect       |     Status:  closed
  Priority:  high         |  Milestone:  PostGIS 2.2.2
 Component:  postgis      |    Version:  1.5.X
Resolution:  invalid      |   Keywords:
--------------------------+---------------------------
Changes (by robe):

 * status:  new => closed
 * resolution:   => invalid
 * milestone:   => PostGIS 2.2.2


Comment:

 This is not  a bug, but by design.  When you use DISTINCT it uses the =
 operator which is tied to bounding box equality not geometry equality.

 You could group by  or distinct on  geom::text to get what you want.

 Anyrate please ask for help on our mailing list, not our bug tracker.

 https://lists.osgeo.org/mailman/listinfo/postgis-users

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