PostGIS：计算一个点与2 fks之间的最小距离：起点和终点

Transport

Spot

origin

destination

SELECT LEAST(
   ST_Distance(ST_GeographyFromText(\'SRID=4326; POINT(-3 40)\'), s.point), 
   ST_Distance(ST_GeographyFromText(\'SRID=4326; POINT(-3 40)\'), s.point)
) FROM spot s RIGHT OUTER JOIN transport t 
ON t.origin = s.id OR t.destination = s.id;

SELECT LEAST(
   ST_Distance(ST_GeographyFromText(\'SRID=4326; POINT(-3 40)\'), sOrigin.point), 
   ST_Distance(ST_GeographyFromText(\'SRID=4326; POINT(-3 40)\'), sDestination.point)
) FROM transport t
LEFT OUTER JOIN spot sOrigin ON t.origin = sOrigin.id 
LEFT OUTER JOIN spot sDestination ON t.destination = sDestination.id;