All Products
Search
Document Center

PolarDB:ST_3DIntersects

Last Updated:Jun 08, 2023

This topic describes the ST_3DIntersects function. This function checks whether two 3D models or 3D geometry objects intersect.

Syntax

bool ST_3DIntersects(meshgeomgeom1, meshgeomgeom2);
bool ST_3DIntersects(meshgeomgeom1,  box3d box);
bool ST_3DIntersects(sfmeshsfmeshObject1, sfmeshsfmeshObject2);

Parameters

Parameter

Description

geom

The meshgeom object.

box

The box3d object.

sfmeshObject

The 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