From: Sarah Hoffmann 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?ds=sidebyside 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