ST_3DIntersects

更新时间: 2026-04-12 04:10:38

Determines whether 3D models and 3D geometries intersect.

Syntax

bool ST_3DIntersects(meshgeom geom1, meshgeom geom2);
bool ST_3DIntersects(meshgeom geom1,  box3d box);
bool ST_3DIntersects(sfmesh sfmeshObject1, sfmesh sfmeshObject2);

Parameters

Parameter name

Description

geom

Meshgeom object

box

Specifies the box3d object.

sfmeshObject

sfmesh object

Description

  • This function checks whether two sfmesh objects intersect.

  • This function checks whether the sfmesh object intersects with the box3d object.

  • This function checks whether two meshgeom objects intersect.

  • If this function fails, NULL is returned.

Examples

select ST_3DIntersects(
    'MESHGEOM(PATCH(TRIANGLESTRIP Z(0 0 0,0 10 0,0 0 10,0 10 10), POINT Z(0 0 0)))'::meshgeom,
    'MESHGEOM(PATCH(LINESTRING(-1 0 0, -1 -0.5 0)))'::meshgeom);

-----------------
 f
上一篇: Functions for spatial relationship identification 下一篇: ST_3DContains
阿里云首页 云原生数据库 PolarDB 相关技术圈