ST_LocateBetween

Determine which elements have m (measure) coordinates that fall within a particular range.

This function operates only for cartesian coordinates.

Syntax

ST_LocateAlong(geo, m1, m2);

geo: The input points, multipoint, linestring, or multilinestring geometry.
Type: VARCHAR(ANY)
m1: The start of the range of measures to be matched.
Type: DOUBLE
m2: The end of the range of measures to be matched.
Type: DOUBLE

Returns

A value of type VARCHAR(ANY) that is a geometry of the same type as the input geometry, and whose vertices are the subset of the vertices of the input geometry that have m coordinates that fall within the specified range. If the input geometry does not contain any such entries, an empty geometry collection is returned.

Examples

SELECT inza..ST_AsText(inza..ST_LocateBetween(inza..ST_WKTToSQL('
       MULTIPOINT(0 0 0 4, 100 0 0 5, 100 100 5 6, 0 100 7 8, 1 0 9 5)'), 5, 8));
 
ST_ASTEXT
-----------
MULTIPOINT ZM (100 0 0 5, 100 100 5 6, 0 100 7 8, 1 0 9 5)
(1 row)