ST_Disjoint

更新时间:
复制 MD 格式

Returns true if two objects share no point in common — no intersection and no touching boundary. Applies to raster-to-raster and raster-to-geometry comparisons.

Syntax

bool ST_Disjoint(raster rast1, raster rast2);
bool ST_Disjoint(raster rast,  geometry geom);
bool ST_Disjoint(geometry geom, raster rast);

Parameters

ParameterDescription
rast1The first raster object
rast2The second raster object
rastA raster object
geomA geometric object

Examples

Filter rows where two rasters are disjoint

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