This function filters all pcpoint objects to obtain the pcpoint objects whose values of the specified attribute dimension are equal to a fixed value in a pcpatch object and returns a new pcpatch object that is composed of these pcpoint objects.
Syntax
pcpatch ST_filterEquals(pcpatch pc, text dimname, float8 value);
Parameters
Parameter | Description |
---|---|
pc | The pcpatch object. |
dimname | The name of the specified attribute dimension. |
value | The fixed value of the attribute dimension. |
Examples
SELECT ST_AsText(ST_FilterEquals(pa, 'y', 45.57)) FROM patches WHERE id = 7;
------------------------------------------------------------
{"pcid":1,"pts":[[-126.42,45.57,58,5],[-126.41,45.57,59,5]]}