[postgis-tickets] [PostGIS] #3899: BTree opclass does not take object length into account

[PostGIS]

#3899: BTree opclass does not take object length into account
----------------------+---------------------------
  Reporter:  komzpa   |      Owner:  komzpa
      Type:  patch    |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 2.4.2
 Component:  postgis  |    Version:  2.4.x
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by pramsey):

 This is an oldy but a goody,
 {{{
 select geometry_cmp('POINT(-0 0)'::geometry, 'POINT(0 0)'::GEometry);

  geometry_cmp
 --------------
             1
 }}}
 I noticed this when checking on whether we could have a hash index to
 support certain CTE use cases. And lo, this old issue, which was never
 really resolved, came up. Do we consider `POINT(-0 0)` equal to `POINT(0
 0)`? I guess not, actually, since we now consider `LINESTRING(0 0, 1 1)`
 to be different from `LINESTRING(1 1, 0 0)`.

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