ST_Covers — Returns 1 (TRUE) if no point in Geometry B is outside Geometry A


boolean ST_Covers(geometry geomA, geometry geomB);


Returns 1 (TRUE) if no point in Geometry B is outside Geometry A

Performed by the GEOS module


Do not call with a GEOMETRYCOLLECTION as an argument


Do not use this function with invalid geometries. You will get unexpected results.

This function call will automatically include a bounding box comparison that will make use of any indexes that are available on the geometries. To avoid index use, use the function _ST_Covers.

Availability: 1.2.2 - requires GEOS >= 3.0

NOTE: this is the "allowable" version that returns a boolean, not an integer.

Not an OGC standard, but Oracle has it too.

There are certain subtleties to ST_Contains and ST_Within that are not intuitively obvious. For details check out Subtleties of OGC Covers, Contains, Within


	--a circle covering a circle
SELECT ST_Covers(smallc,smallc) As smallinsmall,
	ST_Covers(smallc, bigc) As smallcoversbig,
	ST_Covers(bigc, ST_ExteriorRing(bigc)) As bigcoversexterior,
	ST_Contains(bigc, ST_ExteriorRing(bigc)) As bigcontainsexterior
FROM (SELECT ST_Buffer(ST_GeomFromText('POINT(1 2)'), 10) As smallc,
	ST_Buffer(ST_GeomFromText('POINT(1 2)'), 20) As bigc) As foo;
 smallinsmall | smallcoversbig | bigcoversexterior | bigcontainsexterior
 t            | f              | t                 | f
(1 row)	

See Also

ST_Contains, ST_CoveredBy, ST_Within