Implementing `st_distance_sphere` to get distance
ptrkhh opened this issue · 0 comments
ptrkhh commented
From what I gathered from the internet, it seems we need the function st_distance_sphere
in order to filter by the distance
For example if we need a distance of under 10 meters, we would do something like
SELECT *
FROM geotable
WHERE st_distance_sphere(POINT(-82.337036, 29.645095 ), POINT(myLon, myLat))/1000 < 10
where myLat
and myLon
is a float value
Is there any chance we could ge this feature implemented in entgo?