X-Git-Url: https://git.openstreetmap.org/nominatim.git/blobdiff_plain/15bca71b0de68c38cd27d29a9ab19bf9832b9f56..0e446590338927bf5251bc569b4e77d6c75a6b5f:/sql/tiger_import_start.sql diff --git a/sql/tiger_import_start.sql b/sql/tiger_import_start.sql index 5acb3e59..ef55e11c 100644 --- a/sql/tiger_import_start.sql +++ b/sql/tiger_import_start.sql @@ -26,6 +26,11 @@ BEGIN endnumber = in_startnumber; END IF; + IF startnumber < 0 THEN + RAISE WARNING 'Negative house number range (% to %) on %, %', startnumber, endnumber, in_street, in_isin; + RETURN 0; + END IF; + numberrange := endnumber - startnumber; IF (interpolationtype = 'odd' AND startnumber%2 = 0) OR (interpolationtype = 'even' AND startnumber%2 = 1) THEN