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