分类：计算两点距离

2021
01-26

postgresql 计算两点距离的2种方法小结

postgresql计算两点距离下面两种方法：selectST_Distance(ST_SetSRID(ST_MakePoint(115.97166453999147,28.716493914230423),4326)::geography,ST_SetSRID(ST_MakePoint(106.00231199774656,29.719258550486572),4326)::geography),ST_Length(ST_MakeLine(ST_MakePoint(115.97166453999147,28.716493914230423),ST_MakePoint(106.00231199774656,29.719258550486572))::geography)备注：ST_GeomFromText('LINESTRING(115.97... 继续阅读 >