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