[postgis-users] Number of vertices in a polygon

Nicolas RIBOT nri at scot.cnes.fr
Wed Dec 3 05:55:52 PST 2003


Hello all,

Is there a simple way to get the total number of vertices in a Polygon
with an SQL query ? (something like numpoints(the_geom), where the_geom
would be a polygon column)

The "summary(geometry)" function is handy, but one must parse its result
in order to build the total number of vertices.

Thanx
Nicolas Ribot



More information about the postgis-users mailing list