ST_Points-ApsaraDB RDS(RDS)-阿里云帮助中心

Returns a MultiPoint object containing all the vertices of the input Geometry object.

Syntax

geometry  ST_Points(geometry  geom);

Parameter Name	Description
geom	The target Geometry object.

This function does not remove duplicate points from the input object, including the start and end points of a circular geometry object.
You can use the ST_RemoveRepeatedPoints function to remove the duplicate points.
If M and Z coordinates exist, they are preserved.
This function supports CircularString and Curve geometry objects.

Basic usage:

SELECT ST_AsText(ST_Points('LINESTRING(0 0,2 2)'::geometry));
      st_astext
---------------------
 MULTIPOINT(0 0,2 2)
(1 row)