X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/04d485c55064afd06f5cc49962caf73734bce5c9..a4f1e40b721a597018e60ec743d190e4fa65bd81:/sql/functions/placex_triggers.sql diff --git a/sql/functions/placex_triggers.sql b/sql/functions/placex_triggers.sql index 7d6352b4..6fd9e225 100644 --- a/sql/functions/placex_triggers.sql +++ b/sql/functions/placex_triggers.sql @@ -814,8 +814,8 @@ BEGIN END IF; - IF array_length(name_vector, 1) is not NULL - OR inherited_address is not NULL OR NEW.address is not NULL + IF not %REVERSE-ONLY% AND (array_length(name_vector, 1) is not NULL + OR inherited_address is not NULL OR NEW.address is not NULL) THEN SELECT * INTO name_vector, nameaddress_vector FROM create_poi_search_terms(NEW.place_id, @@ -824,7 +824,7 @@ BEGIN NEW.country_code, NEW.housenumber, name_vector, NEW.centroid); - IF not %REVERSE-ONLY% AND array_length(name_vector, 1) is not NULL THEN + IF array_length(name_vector, 1) is not NULL THEN INSERT INTO search_name (place_id, search_rank, address_rank, importance, country_code, name_vector, nameaddress_vector, centroid)