[postgis-users] Nearest neighbor in 3D

[Bartosz Bekier]

Hello All!

This is my first post on the PostGIS mailing list:-).

I would like to use the <-> to solve the nearest neighbor problem, but in
3D space. I tried to do this in 2D and it works perfectly, but apparently
it doesn't cover the 3D case.

Basically I have a table of 3D points (x, y, z) and would like to do:

    ORDER BY point <-> POINT(0 0 0)

but the distance taken into account should be 3D Euclidean distance. Do I
have to use ST_3DDistance() for it or is there a faster way?

Thanks in advance!

Regards,
-- 
Bartosz Bekier
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120525/fd3a098d/attachment.html>