asset.copy.price is NUMERIC(8,2),

                not NUMERIC(6,2).

diff --git a/sql/base/base.sql b/sql/base/base.sql
index fa60773..95255e2 100644 (file)
--- a/sql/base/base.sql
+++ b/sql/base/base.sql
@@ -650,21 +650,21 @@ CREATE OR REPLACE FUNCTION migration_tools.attempt_date (TEXT,TEXT) RETURNS DATE
     END;
 $$ LANGUAGE PLPGSQL STRICT STABLE;
 
-CREATE OR REPLACE FUNCTION migration_tools.attempt_money (TEXT,TEXT) RETURNS NUMERIC(6,2) AS $$
+CREATE OR REPLACE FUNCTION migration_tools.attempt_money (TEXT,TEXT) RETURNS NUMERIC(8,2) AS $$
     DECLARE
         attempt_value ALIAS FOR $1;
         fail_value ALIAS FOR $2;
-        output NUMERIC(6,2);
+        output NUMERIC(8,2);
     BEGIN
         FOR output IN
-            EXECUTE 'SELECT ' || quote_literal(attempt_value) || '::NUMERIC(6,2) AS a;'
+            EXECUTE 'SELECT ' || quote_literal(attempt_value) || '::NUMERIC(8,2) AS a;'
         LOOP
             RETURN output;
         END LOOP;
     EXCEPTION
         WHEN OTHERS THEN
             FOR output IN
-                EXECUTE 'SELECT ' || quote_literal(fail_value) || '::NUMERIC(6,2) AS a;'
+                EXECUTE 'SELECT ' || quote_literal(fail_value) || '::NUMERIC(8,2) AS a;'
             LOOP
                 RETURN output;
             END LOOP;