X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/166737fb76268d58142e0519b3124ef6adcdef19..203b5f7de12ca09d275103eb2eb70fe5a4c20466:/sql/words.sql?ds=sidebyside 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