This topic describes the ST_overlaps function. This function identifies the spatial relationship between two raster objects or between a raster object and a geometric object to determine whether the first specified object overlaps with the second.
bool ST_overlaps(raster rast1, raster rast2); bool ST_overlaps(raster rast, geometry geom); bool ST_overlaps(geometry geom, raster rast);
|rast1||The raster object 1.|
|rast2||The raster object 2.|
|rast||A raster object.|
|geom||A geometric object.|
SELECT a.id FROM tbl_a a, tbl_b b WHERE ST_Contains(a.rast, b.rast)