X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/4c7145c2938022d8355f49eb89a5ae1a68217a18..626e3238f27d972614ad3c0e978605facf0f9bd2:/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