Mercurial > gemma
comparison pkg/controllers/gauges.go @ 2913:cf6f595af2cb
Fixed SQL statement for nash sutcliffe calculation.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Wed, 03 Apr 2019 11:30:24 +0200 |
parents | fe3d5e824ee9 |
children | 09d1ffce3d00 |
comparison
equal
deleted
inserted
replaced
2912:93fa55bce126 | 2913:cf6f595af2cb |
---|---|
40 measure_date, | 40 measure_date, |
41 predicted, | 41 predicted, |
42 water_level | 42 water_level |
43 FROM waterway.gauge_measurements | 43 FROM waterway.gauge_measurements |
44 WHERE | 44 WHERE |
45 a.fk_gauge_id = ( | 45 fk_gauge_id = ( |
46 $1::char(2), | 46 $1::char(2), |
47 $2::char(3), | 47 $2::char(3), |
48 $3::char(5), | 48 $3::char(5), |
49 $4::char(5), | 49 $4::char(5), |
50 $5::int | 50 $5::int |