From 9a18b68cfb580691ddd02a73e936c7cad4aa3d72 Mon Sep 17 00:00:00 2001 From: Daniel Friesel Date: Sun, 22 Mar 2015 18:50:51 +0100 Subject: index: fix stddev/count order in realtime-Rate --- index.pl | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'index.pl') diff --git a/index.pl b/index.pl index 9ff4ed9..6e3df19 100644 --- a/index.pl +++ b/index.pl @@ -424,8 +424,9 @@ get '/2ddata.tsv' => sub { when ('realtime_rate') { $query = qq{ select $format as aggregate, avg((delay is not null)::int), + count(*), stddev_samp((delay is not null)::int), - count(*), sum((delay is not null)::int) + sum((delay is not null)::int) from departures $join_clause where $where_clause -- cgit v1.2.3