X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/dd7912ff55b68944070b0bb5e3649baff2584878..4498b89a7501f95a41113e8d4086f7d750c8e2c0:/sql/functions.sql

diff --git a/sql/functions.sql b/sql/functions.sql
index a5d0f6a0..898cdb69 100644
--- a/sql/functions.sql
+++ b/sql/functions.sql
@@ -689,7 +689,7 @@ BEGIN
     -- one with the smallest id because the original node was created first.
     -- Ignore all nodes marked for deletion. (Might happen when the type changes.)
     select * from placex where osm_type = 'N' and osm_id = waynodes[nodeidpos]::BIGINT
-                               and indexed_status < 100
+                               and indexed_status < 100 and housenumber is not NULL
                          order by (type = 'address'),place_id limit 1 INTO nextnode;
     IF nextnode.place_id IS NOT NULL THEN