changeset 3009:ddc4d54b8331

Remove unnecessary subselect
author Tom Gottfried <tom@intevation.de>
date Thu, 11 Apr 2019 12:11:17 +0200
parents f394e828a6d2
children 293bdd05ffcd
files schema/geoserver_views.sql
diffstat 1 files changed, 3 insertions(+), 4 deletions(-) [+]
line wrap: on
line diff
--- a/schema/geoserver_views.sql	Thu Apr 11 12:01:27 2019 +0200
+++ b/schema/geoserver_views.sql	Thu Apr 11 12:11:17 2019 +0200
@@ -14,10 +14,9 @@
         json_strip_nulls(json_object_agg(coalesce(r.depth_reference,'empty'),
                                                   r.value))
             AS reference_water_levels
-    FROM waterway.gauges g LEFT JOIN LATERAL (
-            SELECT gauge_id, depth_reference, value
-            FROM waterway.gauges_reference_water_levels
-            ) r ON r.gauge_id = g.location
+    FROM waterway.gauges g
+        LEFT JOIN waterway.gauges_reference_water_levels r
+            ON r.gauge_id = g.location
     GROUP BY g.location;
 
 CREATE OR REPLACE VIEW waterway.distance_marks_geoserver AS