X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/051998dd80b0def50058266b7adbdf2e971032eb..4b5e464e12473a7d06ab1ecaed8c507350959ee4:/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