Index: openacs-4/packages/ecommerce/sql/postgresql/ecommerce-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/sql/postgresql/ecommerce-create.sql,v
diff -u -r1.8 -r1.9
--- openacs-4/packages/ecommerce/sql/postgresql/ecommerce-create.sql	20 Aug 2001 04:04:09 -0000	1.8
+++ openacs-4/packages/ecommerce/sql/postgresql/ecommerce-create.sql	21 Aug 2001 04:43:45 -0000	1.9
@@ -3143,8 +3143,8 @@
 returns numeric as '
 DECLARE
 	v_gift_certificate_id	alias for $1;
-        original_amount         number;
-        amount_used             number;
+        original_amount         numeric;
+        amount_used             numeric;
 BEGIN
         SELECT coalesce(sum(amount_used),0) - coalesce(sum(amount_reinstated),0)
 	into amount_used