ST_CoveredBy-PolarDB(PolarDB)-阿里云帮助中心

Returns true if no points of the first raster or geometry object lie outside the second object, within the same spatial reference system (SRS).

ST_CoveredBy is the converse of ST_Covers: ST_CoveredBy(A, B) equals ST_Covers(B, A).

Syntax

Raster vs. raster

bool ST_CoveredBy(raster rast1, raster rast2);

Raster vs. geometry

bool ST_CoveredBy(raster rast, geometry geom);
bool ST_CoveredBy(geometry geom, raster rast);

Parameter	Description
`rast1`	The raster object to test.
`rast2`	The raster object that may cover `rast1`.
`rast`	A raster object.
`geom`	A geometry object.

Query all rows in tbl_a whose raster is covered by at least one raster in tbl_b:

SELECT a.id FROM tbl_a a, tbl_b b WHERE ST_CoveredBy(a.rast, b.rast);

Expected output:

 id
----
  1
(1 row)