ST_intersects_云数据库 RDS(RDS)-阿里云帮助中心

判断两个pcpatch对象的外包框是否相交。

语法

boolean ST_intersects(pcpatch pp1, pcpatch pp2);
boolean ST_intersects(geometry g,  pcpatch pp1);

参数

参数名称	描述
pp1	pcpatch对象1。
pp2	pcpatch对象2。
g	Ganos Geometry的geometry对象。

示例

-- Patch should intersect itself
SELECT ST_Intersects(
         '01010000000000000001000000C8CEFFFFF8110000102700000A00'::pcpatch,
         '01010000000000000001000000C8CEFFFFF8110000102700000A00'::pcpatch);
------------------------
t

SELECT ST_Intersects('SRID=4326;POINT(-126.451 45.552)'::geometry, pa) FROM patches WHERE id = 7;
------------------------
t