--- android/TrainInfoService/src/dk/thoerup/traininfoservice/SavedStatistics.java 2010/07/07 16:08:04 967 +++ android/TrainInfoService/src/dk/thoerup/traininfoservice/SavedStatistics.java 2010/07/07 18:54:52 968 @@ -53,7 +53,8 @@ String sqlAvg = "SELECT count(*) AS count, round(avg(location+name+favorites),1) AS station, round(avg(location),1) as location, round(avg(name),1) as name, round(avg(favorites),1) as favorites, " + "round(avg(departure),1) as departure, round(avg(depcache),1) as depcache, round(avg(deperror),1) as deperror, " + "round(avg(timetable),1) as timetable, round(avg(timecache),1) as timecache, round(avg(timeerror),1) as timeerror " + - "FROM trainstatistics"; + "FROM trainstatistics " + + "WHERE statisticsdate <> now()::date "; ResultSet resAvg = stmt.executeQuery(sqlAvg); resAvg.next();