[postgis-users] Operator does not exist: <<#>>

Dapeng Wang wangdapeng20191008 at gmail.com
Tue Dec 26 19:26:14 PST 2023


I get it, <<#>> is deprecated.
<<->>Supports 2D and 3D operations, shortest distance.
I also verified via SQL that <<->> is indeed the shortest distance.

There are 2 questions here,
1. The centroid algorithm disappears.
2. How to calculate bounding box distance used in 3D? Initially use <<#>>.
(Please don't increase the team's development time because of my question,
I have no real application, just learning).

SELECT ST_GeomFromText('MULTIPOINT(1 3 2, 0 0 0)') <<->>
ST_GeomFromText('LINESTRING(1 1 1, 5 5 5)') returns 1.4142135623730951
SELECT ST_3DDistance(ST_GeomFromText('MULTIPOINT(1 3 2, 0 0 0)'),
ST_GeomFromText('LINESTRING(0 0 0, 5 5 5)'))
Haha, the LINESTRING data of the ST_3DDistance function should be
LINESTRING(1 1 1, 5 5 5), which is unintentional.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20231227/920a6082/attachment.htm>


More information about the postgis-users mailing list