public class ST_Contains
extends TwoGeoFunction
Determines if geometry1 contains geometry2, returning true or false.
Format:
ST_Contains(geometry1 ST_Geometry, geometry2 ST_Geometry, tolerance NUMBER) - return true if geometry1 contains geometry2
geometry1 has to be any polygon or any solid.
The tolerance at which geometry2 is valid is optional.
By default the tolerance is 0.05 for geodetic geometries and 0 for non geodetic.
Example:
select ST_Contains(
ST_Polygon('{"type": "Polygon","coordinates": [[[1, 2], [5, 2], [5, 6], [1, 6], [1, 2]]]}', 8307),
ST_Point('{ "type": "Point", "coordinates": [2, 3]}', 8307)
) from hivetable LIMIT 1; -- return true