changeset 5233:d6374435111a new-fwa

Fixed order of parameters in SQL result.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Tue, 12 May 2020 14:16:30 +0200
parents 40f09b2afd01
children 30a55f46996f
files pkg/controllers/fwa.go
diffstat 1 files changed, 3 insertions(+), 3 deletions(-) [+]
line wrap: on
line diff
--- a/pkg/controllers/fwa.go	Tue May 12 14:10:47 2020 +0200
+++ b/pkg/controllers/fwa.go	Tue May 12 14:16:30 2020 +0200
@@ -34,8 +34,8 @@
 const (
 	selectBottlenecksLimitingSQL = `
 SELECT
-  lower(validity)::timestamp with time zone,
-  upper(validity)::timestamp with time zone,
+  lower(validity),
+  upper(validity),
   limiting
 FROM
   waterway.bottlenecks
@@ -570,9 +570,9 @@
 			upper    sql.NullTime
 		)
 		if err := rows.Scan(
-			&limiting,
 			&lv.lower,
 			&upper,
+			&limiting,
 		); err != nil {
 			return nil, err
 		}