X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/b7704833e4b011541928372a46ea692c3a496b5c..60c1301fca135c2581d8372bfd26e256cae87491:/lib-sql/tokenizer/icu_tokenizer.sql diff --git a/lib-sql/tokenizer/icu_tokenizer.sql b/lib-sql/tokenizer/icu_tokenizer.sql index f86a0a37..599d0eb0 100644 --- a/lib-sql/tokenizer/icu_tokenizer.sql +++ b/lib-sql/tokenizer/icu_tokenizer.sql @@ -97,13 +97,6 @@ AS $$ $$ LANGUAGE SQL IMMUTABLE STRICT; -CREATE OR REPLACE FUNCTION token_normalized_postcode(postcode TEXT) - RETURNS TEXT -AS $$ - SELECT CASE WHEN postcode SIMILAR TO '%(,|;)%' THEN NULL ELSE upper(trim(postcode))END; -$$ LANGUAGE SQL IMMUTABLE STRICT; - - CREATE OR REPLACE FUNCTION token_get_postcode(info JSONB) RETURNS TEXT AS $$