Tests if a geometry value spatially covers another geometry value.
SELECT NEW ST_Polygon( 'Polygon(( 0 0, 2 0, 1 2, 0 0 ))' ) .ST_Covers( NEW ST_Point( 1, 1 ) )
The following example tests if a polygon covers a line. The polygon completely covers the line so the example returns 1. If ST_Contains was used in place of ST_Covers, ST_Contains would return 0.
SELECT NEW ST_Polygon( 'Polygon(( 0 0, 2 0, 1 2, 0 0 ))' ) .ST_Covers( NEW ST_LineString( 'LineString( 0 0, 1 0 )' ) )
The following example lists the ShapeIDs where the given polygon covers each Shape geometry. This example returns the result 1,16,17,19,26. Note that ShapeID 1 is listed even though the polygon intersects that row's Shape point only at the polygon's boundary.
SELECT LIST( ShapeID ORDER BY ShapeID ) FROM SpatialShapes WHERE NEW ST_Polygon( NEW ST_Point( 0, 0 ), NEW ST_Point( 8, 2 ) ).ST_Covers( Shape ) = 1
SQL/MM (ISO/IEC 13249-3: 2006) Vendor extension