details page: differentiate between spheric distance and distance in meters

[nominatim.git] / sql / words.sql

diff --git a/sql/words.sql b/sql/words.sql
index 654fee70639e12035b5892e567c970c10057f0d8..ac379221c69def092639b340fbe5659b2332443e 100644 (file)
--- 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);
 
     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
 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