I want to calculate the distance in meters between two points but I am getting
an obscene result
Here is the query I made:
SELECT ST_Distance(ST_SeTSRID(ST_MakePoint(6761331.47, 2873883.72), 2154), ST_SeTSRID(ST_MakePoint(2873464.28, 6761335.07), 2154)), ST_Distance(ST_MakePoint(6761331.47, 2873883.72), ST_MakePoint(2873464.28, 6761335.07))
The coordinates are in the
What should I do to get a good result? I tried with the 4326 SRID and the appropriate coordinates and got a wrong answer as well.