https://supabase.com/ logo
#sql
Title
# sql
t

TremalJack

12/31/2021, 2:39 PM
guys not a supabase related question, but... somebody of u have a postgres function to calc distance (km) betweend 2 coordinates?
s

Scott P

12/31/2021, 2:59 PM
Make sure the PostGIS extensions are enabled, and then the results on Google will work, for example: https://postgis.net/docs/ST_Distance.html https://stackoverflow.com/questions/24624257/postgis-distance-calculation
t

TremalJack

12/31/2021, 7:51 PM
I want run a query where the coordinates are below or equal 300km
s

Scott P

12/31/2021, 9:56 PM
That's an entirely different question to the one you originally asked, and I'd suggest Googling for answers
s

Subramanya Chakravarthy

01/01/2022, 1:36 PM
I recently worked on postgis and collected some notes here https://notes.fyndx.io/Computer+Science/Programming/Database/Postgres/PostGis
t

TremalJack

01/01/2022, 1:55 PM
sorry sometimes my english s*ck xD
awesome article! good job!