--- a/schema/search_functions.sql	Wed May 22 15:38:21 2019 +0200
+++ b/schema/search_functions.sql	Wed May 22 15:56:33 2019 +0200
@@ -69,12 +69,32 @@
 END;
 $$;
 
+CREATE OR REPLACE FUNCTION search_sections(search_string text) RETURNS jsonb
+  LANGUAGE plpgsql
+  AS $$
+DECLARE
+  _result jsonb;
+BEGIN
+  SELECT COALESCE(json_agg(r),'[]')
+    INTO _result
+    FROM (SELECT objnam AS name,
+                 ST_AsGeoJSON(ST_Centroid(area))::json AS geom,
+                 'section' AS type
+            FROM waterway.sections
+            WHERE objnam ILIKE '%' || search_string || '%'
+               OR nobjnam ILIKE '%' || search_string || '%'
+          ORDER BY name) r;
+  RETURN _result;
+END;
+$$;
+
 CREATE OR REPLACE FUNCTION search_most(search_string text) RETURNS jsonb
   LANGUAGE plpgsql
   AS $$
 BEGIN
   RETURN search_bottlenecks(search_string)
          || search_gauges(search_string)
+         || search_sections(search_string)
          || search_cities(search_string);
 END;
 $$;