# HG changeset patch
# User Sascha Wilde <wilde@intevation.de>
# Date 1561370288 -7200
# Node ID e1bd5391a4b8604e89a0a4b817874dceb08a3a92
# Parent  9f20d2b59d4c410619710dd17bd822fa2dd621d2
Use correct existing function to convert ISRS code to string.

diff -r 9f20d2b59d4c -r e1bd5391a4b8 schema/search_functions.sql
--- a/schema/search_functions.sql	Mon Jun 24 11:56:38 2019 +0200
+++ b/schema/search_functions.sql	Mon Jun 24 11:58:08 2019 +0200
@@ -21,7 +21,7 @@
     SELECT COALESCE(json_agg(r),'[]')
       INTO _result
       FROM (SELECT (location_code).hectometre || ' rhm' AS name,
-  			replace(concat(location_code), ',','') AS locationcode,
+                        isrs_asText(location_code) AS locationcode,
                ST_AsGeoJSON(geom)::json AS geom, 'rhm' AS type
         FROM waterway.distance_marks_virtual
         WHERE (location_code).hectometre = search_string::int) r;
@@ -29,7 +29,7 @@
     SELECT COALESCE(json_agg(r),'[]')
       INTO _result
       FROM (SELECT (location_code).hectometre || ' rhm' AS name,
-  			replace(concat(location_code), ',','') AS locationcode,
+                        isrs_asText(location_code) AS locationcode,
                ST_AsGeoJSON(geom)::json AS geom, 'rhm' AS type
         FROM waterway.distance_marks_virtual
         WHERE location_code = isrs_fromText(search_string)) r;