Mercurial > gemma
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