a8m/entspatial

Implementing `st_distance_sphere` to get distance

ptrkhh opened this issue · 0 comments

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?