ST_patchMin

更新时间:
复制 MD 格式

Returns the minimum value of a specified attribute dimension across all pcpoint objects in a pcpatch object.

Syntax

numeric ST_patchMin(pcpatch pc, text dimname);

Parameters

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

Examples

The following example returns the minimum intensity value from the patch with id = 7.

SELECT ST_PatchMin(pa, 'intensity') FROM patches WHERE id = 7;

Output:

0.25122