Mercurial > gemma

diff pkg/models/sr.go @ 3645:02951a62e8c6

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
'Historicise' bottlenecks on import
author Tom Gottfried <tom@intevation.de>
date Wed, 12 Jun 2019 17:11:15 +0200
parents 479da494bc09
children 2a079d0a71c1
line wrap: on
line diff
--- a/pkg/models/sr.go	Wed Jun 12 17:10:49 2019 +0200
+++ b/pkg/models/sr.go	Wed Jun 12 17:11:15 2019 +0200
@@ -41,7 +41,8 @@
   FROM waterway.bottlenecks bn
     JOIN waterway.gauges g
       ON bn.gauge_location = g.location AND bn.gauge_validity = g.validity
-    JOIN waterway.gauges_reference_water_levels rl USING (location, validity)
+    JOIN waterway.gauges_reference_water_levels rl
+      ON g.location = rl.location AND g.validity = rl.validity
   WHERE bn.objnam = $1
     AND rl.depth_reference = $2)`