ST_makePoint-PolarDB(PolarDB)-阿里云帮助中心

Constructs a pcpoint object from a point cloud schema ID and a coordinate array.

Syntax

pcpoint ST_makePoint(integer pcid, float8[] vals);

Parameter	Description
`pcid`	The ID of the point cloud schema. To get this value, query the `pointcloud_formats` table.
`vals`	The coordinate values as a `float8` array. The number of elements must match the number of dimensions defined in the schema.

Note

Before calling ST_makePoint, create the point cloud extension and define a point cloud schema. For details, see Syntax.

SELECT ST_makePoint(1, ARRAY[-127, 45, 124.0, 4.0]);

Output:

              st_makepoint
----------------------------------------
 010100000064CEFFFF94110000703000000400
(1 row)