[postgis-tickets] [PostGIS] #4139: Unstable behavior of gist nd indexes

[PostGIS]

#4139: Unstable behavior of gist nd indexes
-----------------------+---------------------------
  Reporter:  ezimanyi  |      Owner:  pramsey
      Type:  defect    |     Status:  new
  Priority:  medium    |  Milestone:  PostGIS 2.4.5
 Component:  postgis   |    Version:  2.4.x
Resolution:            |   Keywords:
-----------------------+---------------------------

Comment (by ezimanyi):

 As an aside comment, shouldn't the function geometrytype report both the Z
 and M dimensions instead of being forced to write an elaborate query such
 as the following one for obtaining the type ?


 {{{
 select distinct substring(st_astext(g) for position('(' in st_astext(g)) -
 1) from tbl_geomcollection_nd order by 1

 "LINESTRING"
 "LINESTRING M "
 "LINESTRING Z "
 "LINESTRING ZM "
 "MULTILINESTRING"
 "MULTILINESTRING M "
 "MULTILINESTRING Z "
 "MULTILINESTRING ZM "
 "MULTIPOINT"
 "MULTIPOINT M "
 "MULTIPOINT Z "
 "MULTIPOINT ZM "
 "MULTIPOLYGON"
 "MULTIPOLYGON M "
 "MULTIPOLYGON Z "
 "MULTIPOLYGON ZM "
 "POINT"
 "POINT M "
 "POINT Z "
 "POINT ZM "
 "POLYGON"
 "POLYGON M "
 "POLYGON Z "
 "POLYGON ZM "

 select distinct geometrytype(g) from tbl_geomcollection_nd order by 1

 "LINESTRING"
 "LINESTRINGM"
 "MULTILINESTRING"
 "MULTILINESTRINGM"
 "MULTIPOINT"
 "MULTIPOINTM"
 "MULTIPOLYGON"
 "MULTIPOLYGONM"
 "POINT"
 "POINTM"
 "POLYGON"
 "POLYGONM"
 }}}

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