From a2f60f23ca81099fd84a9f0f02b2c347a5475a83 Mon Sep 17 00:00:00 2001 From: Ben Ostrowsky Date: Tue, 2 Feb 2010 15:55:35 +0000 Subject: [PATCH] asset.copy.price is NUMERIC(8,2), not NUMERIC(6,2). --- sql/base/base.sql | 8 ++++---- 1 files changed, 4 insertions(+), 4 deletions(-) diff --git a/sql/base/base.sql b/sql/base/base.sql index fa60773..95255e2 100644 --- 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; -- 1.7.2.5