Database Reference
In-Depth Information
SELECT earth_distance(
(SELECT ll_to_earth(latitude, longitude) FROM attractions
WHERE name = 'Christ the Redeemer (statue)'),
(SELECT ll_to_earth(latitude, longitude) FROM attractions
WHERE name = 'Maracana Stadium')
);
earth_distance
------------------
4864.08588226038
There are other possibilities for this extension; visit the documentation at ht-
tp://www.postgresql.org/docs/current/static/earthdistance.html .
Search WWH ::




Custom Search