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]]}