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

Retrieves attribute dimension values from a pcpoint object.

Call ST_get with a dimension name to get a single value, or without a dimension name to get all values as an array.

Syntax

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

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

Syntax form	Return type	Description
`ST_get(pc)`	`float8[]`	All attribute dimension values, returned as an array.
`ST_get(pc, dimname)`	`numeric`	The value of the specified attribute dimension.

Retrieve the value of the Intensity dimension:

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

Result:

Retrieve all attribute dimension values:

SELECT ST_Get('010100000064CEFFFF94110000703000000400'::pcpoint);

Result:

{-127,45,124,4}