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
| Parameter | Description |
|---|---|
rast1 | The first raster object |
rast2 | The second raster object |
rast | A raster object |
geom | A 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);该文章对您有帮助吗?