X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/e8b43eeaadd1c2c5f220438ab0fc00a1fae351ce..a038582e34d73ac2575572c9dec0e890557fb0f5:/sql/functions.sql diff --git a/sql/functions.sql b/sql/functions.sql index ccdb5431..6ad13892 100644 --- a/sql/functions.sql +++ b/sql/functions.sql @@ -793,7 +793,7 @@ BEGIN linestr := linestr||','||ST_X(nextnode.geometry)||' '||ST_Y(nextnode.geometry); endnumber := ('0'||substring(nextnode.housenumber,'[0-9]+'))::integer; - IF startnumber IS NOT NULL and startnumber > 0 AND endnumber IS NOT NULL and endnumber > 0 THEN + IF startnumber IS NOT NULL and startnumber > 0 AND endnumber IS NOT NULL and endnumber > 0 AND @(startnumber - endnumber) < 1000 THEN --RAISE WARNING 'interpolation end % % ',nextnode.place_id,endnumber;