From: Sarah Hoffmann <lonvia@denofr.de>
Date: Sat, 28 Oct 2017 16:24:01 +0000 (+0200)
Subject: precomputed postcodes must use dedicated import function
X-Git-Tag: v3.1.0~21
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/e523b34db97d1a1f9ab3b0b07cf12f114a5166a1

precomputed postcodes must use dedicated import function
---

diff --git a/sql/words.sql b/sql/words.sql
index 654fee70..ac379221 100644
--- a/sql/words.sql
+++ b/sql/words.sql
@@ -4,7 +4,7 @@ CREATE TABLE word_frequencies AS
     WHERE v is not null
  GROUP BY id);
 
-select count(make_keywords(v)) from (select distinct address->'postcode' as v from place where address ? 'postcode') as w where v is not null;
+select count(getorcreate_postcode_id(v)) from (select distinct address->'postcode' as v from place where address ? 'postcode') as w where v is not null;
 select count(getorcreate_housenumber_id(make_standard_name(v))) from (select distinct address->'housenumber' as v from place where address ? 'housenumber') as w;
 
 -- copy the word frequencies