X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/4a3dc3187cc5d220f2728a741d4b6789917655c0..07cbf1535bf4297136188565ed56e9bd53c5e6e7:/sql/functions.sql

diff --git a/sql/functions.sql b/sql/functions.sql
index e404da7c..658771b7 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