X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/d1a9dc0f24c9a3a9afbc85a22532b12b05850590..e4555a208dfd3343384095a003060d8d23000fc3:/sql/functions.sql?ds=sidebyside diff --git a/sql/functions.sql b/sql/functions.sql index b2caf0a6..09033567 100644 --- a/sql/functions.sql +++ b/sql/functions.sql @@ -1358,7 +1358,7 @@ BEGIN END LOOP; NEW.importance := null; - SELECT importance, wikipedia + SELECT wikipedia, importance FROM compute_importance(NEW.extratags, NEW.country_code, NEW.osm_type, NEW.osm_id) INTO NEW.wikipedia,NEW.importance; @@ -2692,7 +2692,9 @@ DECLARE match RECORD; result place_importance; BEGIN - FOR match IN SELECT * FROM get_wikipedia_match(extratags, country_code) LOOP + FOR match IN SELECT * FROM get_wikipedia_match(extratags, country_code) + WHERE language is not NULL + LOOP result.importance := match.importance; result.wikipedia := match.language || ':' || match.title; RETURN result;