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)