X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/32a5f812a9c68bbfc9230bb40439c75a49eb08e0..22bd9c4993ecb07d6c0b4f95d35c98bdfd98660d:/lib-sql/functions/placex_triggers.sql

diff --git a/lib-sql/functions/placex_triggers.sql b/lib-sql/functions/placex_triggers.sql
index 2c1b3bdb..f8580d7f 100644
--- a/lib-sql/functions/placex_triggers.sql
+++ b/lib-sql/functions/placex_triggers.sql
@@ -120,7 +120,7 @@ BEGIN
       IF location.members[i+1] = 'street' THEN
         FOR parent IN
           SELECT place_id from placex
-           WHERE osm_type = upper(substring(location.members[i], 1, 1))
+           WHERE osm_type = upper(substring(location.members[i], 1, 1))::char(1)
                  and osm_id = substring(location.members[i], 2)::bigint
                  and name is not null
                  and rank_search between 26 and 27