X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/e8b43eeaadd1c2c5f220438ab0fc00a1fae351ce..399cb31507ce9c53e1be2b8606a9070c2bc132fb:/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;