Mercurial > gemma
view schema/updates/1439/01.add_bn_id_to_bn_overview.sql @ 5624:29d729607ac1
Added tag v5.7 for changeset ff0af91a7f62
author | Sascha Wilde <wilde@sha-bang.de> |
---|---|
date | Thu, 22 Dec 2022 18:42:14 +0100 |
parents | 0b051ee3f238 |
children |
line wrap: on
line source
-- Add bottleneck_id column to bottleneck_overview view. UPDATE sys_admin.published_services SET view_def = $$ SELECT objnam AS name, bn.bottleneck_id, ST_Centroid(area) AS point, (lower(stretch)).hectometre AS from, (upper(stretch)).hectometre AS to, sr.current::text, responsible_country FROM waterway.bottlenecks bn LEFT JOIN ( SELECT bottleneck_id, max(date_info) AS current FROM waterway.sounding_results GROUP BY bottleneck_id) sr ON sr.bottleneck_id = bn.bottleneck_id WHERE bn.validity @> current_timestamp ORDER BY objnam $$ WHERE schema = 'waterway' AND name = 'bottleneck_overview';