Mercurial > gemma

changeset 2763:a06d11d1f0b3

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fixed gauge selection in Nash Sutcliffe calculation.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Thu, 21 Mar 2019 18:19:44 +0100
parents f95ec0bb565c
children f0846d200ce4
files pkg/controllers/gauges.go
diffstat 1 files changed, 8 insertions(+), 8 deletions(-) [+]
line wrap: on
line diff
--- a/pkg/controllers/gauges.go	Thu Mar 21 18:07:49 2019 +0100
+++ b/pkg/controllers/gauges.go	Thu Mar 21 18:19:44 2019 +0100
@@ -43,11 +43,11 @@
      a.predicted AND NOT b.predicted
 WHERE
   a.fk_gauge_id = (
-    $1::char(1),
-	$2::char(2),
-	$3::char(3),
-	$4::char(4),
-	$5::int
+    $1::char(2),
+    $2::char(3),
+    $3::char(5),
+    $4::char(5),
+    $5::int
   ) AND
   a.measure_date BETWEEN
     $6::timestamp AND $6::timestamp - '72hours'::interval
@@ -76,9 +76,9 @@
     $4::char(5),
     $5::int
   ) 
-  AND
-    measure_date BETWEEN
-	  $6::timestamp with time zone AND $7::timestamp with time zone
+  AND measure_date BETWEEN
+    $6::timestamp with time zone AND
+    $7::timestamp with time zone
 ORDER BY measure_date
 `
 )