This topic describes the ST_3DDFullyWithin function. This function checks whether the distance between any two points on two 3D geometry objects is less than a specified distance. If the distance is less than the specified distance, this function returns True. Otherwise, this function returns False.

Syntax

boolean  ST_3DDFullyWithin(geometry  g1 , geometry  g2 , double  precision distance);

Parameters

Parameter Description
g1 The first geometry object that you want to specify.
g2 The second geometry object that you want to specify.
distance The distance limit that you want to specify. The distance is measured in the unit that is specified by the spatial reference system of the geometry objects.

Description

  • The two geometry objects that you specify must use the same projection method and have the same spatial reference identifier (SRID).
  • This function automatically compares the bounding boxes of the geometry objects that you specify by using all available indexes on the geometry objects.
  • This function supports 3D objects and does not delete z coordinates.
  • This function supports polyhedral surfaces.

Examples

The following example shows the difference between this function and the ST_3DDWithin function:
SELECT ST_3DDWithin(g1,g2,2), ST_3DDFullyWithin(g1,g2,2) from (SELECT 'LINESTRING(0 1 0,1 1 0)'::geometry as g1,
                                                                               'LINESTRING(0 0 0,0 -1 0)'::geometry as g2) as test;
 st_3ddwithin | st_3ddfullywithin
--------------+-------------------
 t            | f
(1 row)