From de1cbc97f24667f096c50d43de133f729199eea4 Mon Sep 17 00:00:00 2001
From: Jason Etheridge <jason@esilibrary.com>
Date: Mon, 23 Mar 2009 02:53:18 +0000
Subject: [PATCH] smarter rebarcoder

---
 sql/base/base.sql |    6 ++++--
 1 files changed, 4 insertions(+), 2 deletions(-)

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;
-- 
1.7.2.5