--- android/TrainInfoService/src/dk/thoerup/traininfoservice/LocateStations.java 2009/09/02 13:49:30 300 +++ android/TrainInfoService/src/dk/thoerup/traininfoservice/LocateStations.java 2009/09/07 12:23:35 301 @@ -33,6 +33,7 @@ " SELECT name,latitude,longitude,stationcode, " + " earth_distance( ll_to_earth(latitude,longitude), ll_to_earth(?,?))::int AS calcdist " + " FROM trainstations " + + " WHERE latitude IS NOT NULL AND longitude IS NOT NULL " + " ) AS trainstations2 " + "ORDER BY calcdist ASC " + "LIMIT 4 ";