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