ST_NumPoints

Introduction: Returns number of points in a LineString

Format: ST_NumPoints(geom: geometry)

Note

If any other geometry is provided as an argument, an IllegalArgumentException is thrown.

SQL Example:

SELECT ST_NumPoints(ST_GeomFromWKT('MULTIPOINT ((0 0), (1 1), (0 1), (2 2))'))

Output:

IllegalArgumentException: Unsupported geometry type: MultiPoint, only LineString geometry is supported.

SQL Example:

SELECT ST_NumPoints(ST_GeomFromText('LINESTRING(0 1, 1 0, 2 0)'))

Output: 3