X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/35c7269bac84241c12bae21d0da8feffc631a729..fe3dba3fd717917301b792ec83472287fa37d205:/sql/functions.sql?ds=inline diff --git a/sql/functions.sql b/sql/functions.sql index 58d3fc7d..1829c63d 100644 --- a/sql/functions.sql +++ b/sql/functions.sql @@ -2200,7 +2200,9 @@ BEGIN -- To paraphrase, if there isn't an existing item, OR if the admin level has changed IF existingplacex.osm_type IS NULL OR - (coalesce(existingplacex.admin_level, 15) != coalesce(NEW.admin_level, 15) AND existingplacex.class = 'boundary' AND existingplacex.type = 'administrative') + (existingplacex.class = 'boundary' AND + ((coalesce(existingplacex.admin_level, 15) != coalesce(NEW.admin_level, 15) AND existingplacex.type = 'administrative') OR + (existingplacex.type != NEW.type))) THEN IF existingplacex.osm_type IS NOT NULL THEN