sanity check for address interpolation

diff --git a/sql/functions.sql b/sql/functions.sql
index ccdb543141e1dbe1f9ff30543d332434578a601d..6ad13892c6341646606a9166e60fe301424b05d4 100644 (file)
--- 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;