This function computes the average value of an attribute dimension for all the pcpoint objects in a pcpatch object.

Syntax

numeric ST_patchAvg(pcpatch pc, text dimname);

Parameters

Parameter Description
pc The pcpatch object.
dimname The name of the specified attribute dimension.

Examples

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