X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/9d74ccf33fd6c442dcfe673169cdd046cfbe40c3..9afebddb16b09e09fa9a74624dcd79475b476f10:/sql/words.sql 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