X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/80f6aca0c22984b79e24a19bc602258dd3caeb34..cb92c82ddfe7b5dd0a5d6f52f675914ada92b13f:/lib-sql/functions/postcode_triggers.sql?ds=sidebyside diff --git a/lib-sql/functions/postcode_triggers.sql b/lib-sql/functions/postcode_triggers.sql index 515b7666..3465e775 100644 --- a/lib-sql/functions/postcode_triggers.sql +++ b/lib-sql/functions/postcode_triggers.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. + -- Trigger functions for location_postcode table. @@ -27,7 +34,7 @@ BEGIN NEW.parent_place_id = 0; FOR location IN SELECT place_id - FROM getNearFeatures(partition, NEW.geometry, NEW.rank_search) + FROM getNearFeatures(partition, NEW.geometry, NEW.geometry, NEW.rank_search) WHERE NOT isguess ORDER BY rank_address DESC, distance asc LIMIT 1 LOOP NEW.parent_place_id = location.place_id;