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

Returns the values of one or all attribute dimensions from a pcpoint object.

Syntax

float8[] ST_get(pcpoint pc);
numeric ST_get(pcpoint pc, text dimname);

Call the first form to retrieve all dimension values as an array. Call the second form with a dimension name to retrieve a single value.

Parameter	Type	Description
`pc`	pcpoint	The pcpoint object.
`dimname`	text	The name of the attribute dimension to retrieve.

Retrieve the value of a single dimension (Intensity) from a pcpoint:

SELECT ST_Get('010100000064CEFFFF94110000703000000400'::pcpoint, 'Intensity');
-------------------
4

Retrieve all dimension values from a pcpoint:

SELECT ST_Get('010100000064CEFFFF94110000703000000400'::pcpoint);
--------------------
{-127,45,124,4}