# HG changeset patch
# User Sascha Wilde <wilde@intevation.de>
# Date 1561369891 -7200
# Node ID 4cc3b28fd87b90f90d797dc0a65aa6e67b8dba67
# Parent  96230eadf96e6de790f48f733474a6c11c6a3714
Ignore erased gauges in search.

diff -r 96230eadf96e -r 4cc3b28fd87b schema/search_functions.sql
--- a/schema/search_functions.sql	Mon Jun 24 11:49:08 2019 +0200
+++ b/schema/search_functions.sql	Mon Jun 24 11:51:31 2019 +0200
@@ -72,7 +72,7 @@
 END;
 $$;
 
-CREATE OR REPLACE FUNCTION search_gauges(search_string text) RETURNS jsonb
+qCREATE OR REPLACE FUNCTION search_gauges(search_string text) RETURNS jsonb
   LANGUAGE plpgsql STABLE PARALLEL SAFE
   AS $$
 DECLARE
@@ -86,7 +86,7 @@
                    ST_AsGeoJSON(geom)::json AS geom,
                    'gauge' AS type
               FROM waterway.gauges
-              WHERE location = isrs_fromText(search_string)
+              WHERE NOT erased AND location = isrs_fromText(search_string)
             ORDER BY name) r;
   ELSE
     SELECT COALESCE(json_agg(r),'[]')
@@ -96,7 +96,7 @@
                    ST_AsGeoJSON(geom)::json AS geom,
                    'gauge' AS type
               FROM waterway.gauges
-              WHERE objname ILIKE '%' || search_string || '%'
+              WHERE NOT erased AND objname ILIKE '%' || search_string || '%'
             ORDER BY name) r;
   END IF;
   RETURN _result;