ST_Contains

Introduction: Return true if A fully contains B

Format: ST_Contains (A:geometry, B:geometry)

SQL example:

SELECT *
FROM pointdf
WHERE ST_Contains(ST_PolygonFromEnvelope(1.0,100.0,1000.0,1100.0), pointdf.arealandmark)