From: Jason Etheridge <jason@esilibrary.com>
Date: Mon, 23 Mar 2009 02:53:18 +0000 (+0000)
Subject: smarter rebarcoder
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=de1cbc97f24667f096c50d43de133f729199eea4

smarter rebarcoder
---

diff --git a/sql/base/base.sql b/sql/base/base.sql
index 1bb2265..c7e5864 100644
--- a/sql/base/base.sql
+++ b/sql/base/base.sql
@@ -185,8 +185,10 @@ CREATE OR REPLACE FUNCTION migration_tools.rebarcode (o TEXT, t BIGINT) RETURNS
     DECLARE
         n TEXT := o;
     BEGIN
-        IF o ~ E'^\\d+$' THEN
-            n = o::INT + t;
+        IF o ~ E'^\\d+$' AND o !~ E'^0' THEN
+            IF o::BIGINT < t THEN
+                n = o::BIGINT + t;
+            END IF;
         END IF;
 
         RETURN n;