X-Git-Url: https://git.openstreetmap.org/nominatim.git/blobdiff_plain/40f9d52ad8b48e0dc6b1ac89305c1e4ef1c43884..5adc3167d833bc2fb73d4a19f3c68b1e7a42ee3e:/lib-sql/functions/utils.sql diff --git a/lib-sql/functions/utils.sql b/lib-sql/functions/utils.sql index f7d2093c..ad262670 100644 --- a/lib-sql/functions/utils.sql +++ b/lib-sql/functions/utils.sql @@ -1,3 +1,10 @@ +-- SPDX-License-Identifier: GPL-2.0-only +-- +-- This file is part of Nominatim. (https://nominatim.org) +-- +-- Copyright (C) 2022 by the Nominatim developer community. +-- For a full list of authors see the git log. + -- Assorted helper functions for the triggers. CREATE OR REPLACE FUNCTION geometry_sector(partition INTEGER, place geometry) @@ -163,15 +170,6 @@ BEGIN -- RAISE WARNING 'near osm fallback: %', ST_AsText(place_centre); - -- - FOR nearcountry IN - SELECT country_code from country_osm_grid - WHERE st_dwithin(geometry, place_centre, 0.5) - ORDER BY st_distance(geometry, place_centre) asc, area asc limit 1 - LOOP - RETURN nearcountry.country_code; - END LOOP; - RETURN NULL; END; $$