ST_filterBetween
Updated at:
This function filters a pcpatch object to find all pcpoint objects whose value for a specified dimension is between a minimum and a maximum value, and returns the matching pcpoint objects as a new pcpatch object.
Syntax
pcpatch ST_filterBetween(pcpatch pc, text dimname, float8 minvalue, float8 maxvalue);Parameters
Parameter name | Description |
pc | The pcpatch object. |
dimname | The name of the specified attribute dimension. |
minvalue | The minimum value for the static field of the property. |
maxvalue | The maximum value of the property's static field. |
Description
The function does not include points where the value is equal to the minimum or maximum value.
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]]}Is this page helpful?