From ec42fda1bde518d74536bc35b877fccc1d483ee1 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Tue, 8 Jul 2025 14:49:16 +0200 Subject: [PATCH] do not add postcodes from postcode boundaries to address vector Postcodes will be found through a special search, so we can save the space. --- lib-sql/functions/placex_triggers.sql | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/lib-sql/functions/placex_triggers.sql b/lib-sql/functions/placex_triggers.sql index 8524ffc3..746ed3c2 100644 --- a/lib-sql/functions/placex_triggers.sql +++ b/lib-sql/functions/placex_triggers.sql @@ -638,8 +638,10 @@ BEGIN -- Add it to the list of search terms {% if not db.reverse_only %} - nameaddress_vector := array_merge(nameaddress_vector, - location.keywords::integer[]); + IF location.rank_address != 11 AND location.rank_address != 5 THEN + nameaddress_vector := array_merge(nameaddress_vector, + location.keywords::integer[]); + END IF; {% endif %} INSERT INTO place_addressline (place_id, address_place_id, fromarea, -- 2.39.5