[postgis-users] ST_DWithin, ST_Distance and <->

Eric St-Georges thevedge at thevedge.net
Mon Nov 12 13:47:28 PST 2018


Looking for official documentation or guidance regarding the usage of
ST_DWithin, ST_Distance and <->, especially when it comes to using
indices. For example, the ST_Distance page[1] itself doesn't mention
that the function will not use indices.
For example: 
If I want to get the closest point to another, why can't ST_Distance use
an index, but <-> can?Is there anyway to get a distance in meters or some other unit from the
<-> operator on geography types?if ST_DWithin and <-> and other similar functions/operators should be
used when dealing with distance, what's the use case for ST_Distance?
Eric St-Georges


  1. https://postgis.net/docs/ST_Distance.html
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20181112/3c7a7991/attachment.html>

More information about the postgis-users mailing list