ST_patchAvg

更新时间:
复制 MD 格式

Computes the average value of an attribute dimension across all pcpoint objects in a pcpatch object.

Syntax

numeric ST_patchAvg(pcpatch pc, text dimname);

Parameters

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

Examples

SELECT ST_PatchAvg(pa, 'intensity') FROM patches WHERE id = 7;
--------------------------
5.0000000000000000