All Products
Search
Document Center

PolarDB:ST_makePoint

Last Updated:Nov 18, 2024

This function constructs a pcpoint object.

Syntax

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

Parameters

Parameter

Description

pcid

The ID of the schema, which comes from the pointcloud_formats table.

float8[]

The float8 array. The number of entries in the array is equal to the number of dimensions specified in the schema.

Examples

Note

You must create the extension and define the point cloud schema before you use the ST_makePoint function. For more information, see Syntax.

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

Sample result:

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