Changes between Version 1 and Version 2 of Ticket #5827, comment 4


Ignore:
Timestamp:
01/05/25 22:22:29 (43 hours ago)
Author:
nbvfgh

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #5827, comment 4

    v1 v2  
    1 Since there is currently no implementation of 3DContains or 3DWithin (at least I haven't seen it in the documentation), I have a simple suggestion. For ST_3DDFullyWithin (a, b, dis), you can use ST_3DClosestPoint(a. b) to first calculate the cloest point from geometry a to geometry b, then use ST_3DMaxDistance(p, b) to calculate the maximum distance from the point p to geometry b, and finally compare the obtained distance with dis.
    21
    3 That is, ST_3DDFullyWithin (A, B, R) <=> ST_3DMaxDistance(ST_3DClosestPoint(A, B), B) <= R && ST_3DMaxDistance(ST_3DClosestPoint(B, A), A) <= R
    4 The same applies to 2D.
     2
     3Yes, but there is currently no implementation of 3DContains or 3DWithin (at least I haven't seen it in the documentation).