I have two points and I have to calculate difference between them.
I using below query in SQL Server.
SELECT geography::Point(27.185425, 88.124582, 4326) .STDistance(geography::Point(27.1854258, 88.124500, 4326));
Its running fine and result is :
Now with same point when I am running below query in PostgreSQL.
SELECT ST_Distance(ST_GeomFromText('POINT(27.185425 88.124582)',4326), ST_GeomFromText('POINT(27.1854258 88.124500)', 4326));
and Now result is :
Can anyone tell me why there is difference in results when calculating distance between two points?