[postgis-devel] [PostGIS] #324: ST_DumpPoints(geom, integer[]) is misnamed

PostGIS trac at osgeo.org
Sun Nov 29 23:54:50 PST 2009


#324: ST_DumpPoints(geom, integer[]) is misnamed
---------------------+------------------------------------------------------
 Reporter:  robe     |       Owner:  kneufeld     
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 1.5.0
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------
 We should either make this function do something cool or rename it to
 _ST_DumpPoints.

 The user in me was thinking
 "Why does this function have no description?  I wonder if the good PostGIS
 developers just forgot to document it.  I wonder if I can extract the
 points of an inner ring in a collection of a polygon by doing"


 {{{
 SELECT path, ST_AsText(geom)
 FROM (
   SELECT (ST_DumpPoints(g.geom,ARRAY[4,2])).*
   FROM
     (SELECT
        'GEOMETRYCOLLECTION(
           POINT ( 0 1 ),
           LINESTRING ( 0 3, 3 4 ),
           POLYGON (( 2 0, 2 3, 0 2, 2 0 )),
           POLYGON (( 3 0, 3 3, 6 3, 6 0, 3 0 ),
                    ( 5 1, 4 2, 5 2, 5 1 )),
           MULTIPOLYGON (
                   (( 0 5, 0 8, 4 8, 4 5, 0 5 ),
                    ( 1 6, 3 6, 2 7, 1 6 )),
                   (( 5 4, 5 8, 6 7, 5 4 ))
           )
         )'::geometry AS geom
     ) AS g
   ) AS j;
 }}}

 To my disappointment -- ehh you can't - its just a  helper function not a
 navigation function.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/324>
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-devel mailing list