Mercurial > gemma
changeset 2763:a06d11d1f0b3
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 ` )