From 7d250895a58a4a5c303c538847d28d6cdd8dc798 Mon Sep 17 00:00:00 2001 From: Brian Quinion Date: Thu, 20 Dec 2012 17:49:37 +0000 Subject: [PATCH] include zip codes for addresses linked to the street in the address search terms --- sql/functions.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) diff --git a/sql/functions.sql b/sql/functions.sql index 1af5fdbf..0d691411 100644 --- a/sql/functions.sql +++ b/sql/functions.sql @@ -1709,6 +1709,16 @@ BEGIN END LOOP; END IF; END IF; + + -- for the USA we have an additional address table. Merge in zip codes from there too + IF NEW.rank_search = 26 AND NEW.calculated_country_code = 'us' THEN + FOR location IN SELECT distinct postcode from location_property_tiger where parent_place_id = NEW.place_id LOOP + address_street_word_id := get_name_id(make_standard_name(location.postcode)); + nameaddress_vector := array_merge(nameaddress_vector, ARRAY[address_street_word_id]); + isin_tokens := isin_tokens || address_street_word_id; + END LOOP; + END IF; + -- RAISE WARNING 'ISIN: %', isin_tokens; -- Process area matches -- 2.39.5