ST_patchMax

更新时间:
复制 MD 格式

Returns the maximum value of a named attribute dimension across all pcpoint objects in a pcpatch object.

Syntax

numeric ST_patchMax(pcpatch pc, text dimname);

Parameters

ParameterDescription
pcThe pcpatch object.
dimnameThe name of the attribute dimension.

Examples

The following example returns the maximum intensity value from the patch stored in the patches table where id = 7.

SELECT ST_PatchMax(pa, 'intensity') FROM patches WHERE id = 7;
--------------------------
125.0000000000000000