From 665446e1a6d4f34cacb39fe350c3c343fc30afe2 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Sun, 18 May 2014 21:45:29 +0200 Subject: [PATCH] omit places with zero address rank from address lookup tables --- sql/partition-functions.src.sql | 15 +++++++++++---- 1 file changed, 11 insertions(+), 4 deletions(-) diff --git a/sql/partition-functions.src.sql b/sql/partition-functions.src.sql index 8857e766..a0181c0a 100644 --- a/sql/partition-functions.src.sql +++ b/sql/partition-functions.src.sql @@ -60,6 +60,9 @@ create or replace function insertLocationAreaLarge( in_centroid GEOMETRY, in_geometry GEOMETRY) RETURNS BOOLEAN AS $$ DECLARE BEGIN + IF in_rank_address = 0 THEN + RETURN TRUE; + END IF; IF in_rank_search <= 4 THEN INSERT INTO location_area_country values (in_partition, in_place_id, in_country_code, in_keywords, in_rank_search, in_rank_address, in_estimate, in_centroid, in_geometry); @@ -205,16 +208,20 @@ BEGIN IF in_rank_search <= 4 THEN DELETE FROM search_name_country WHERE place_id = in_place_id; - INSERT INTO search_name_country values (in_place_id, in_rank_search, in_rank_address, - in_name_vector, in_geometry); + IF in_rank_address > 0 THEN + INSERT INTO search_name_country values (in_place_id, in_rank_search, in_rank_address, + in_name_vector, in_geometry); + END IF; RETURN TRUE; END IF; -- start IF in_partition = -partition- THEN DELETE FROM search_name_-partition- values WHERE place_id = in_place_id; - INSERT INTO search_name_-partition- values (in_place_id, in_rank_search, in_rank_address, - in_name_vector, in_geometry); + IF in_rank_address > 0 THEN + INSERT INTO search_name_-partition- values (in_place_id, in_rank_search, in_rank_address, + in_name_vector, in_geometry); + END IF; RETURN TRUE; END IF; -- end -- 2.39.5