From a5b4492c809c787c61f613e08ac2ed46f67cf8b4 Mon Sep 17 00:00:00 2001
From: linuxpoet <linuxpoet@4979c152-3d1c-0410-bac9-87ea11338e46>
Date: Fri, 13 Apr 2007 00:36:33 +0000
Subject: fix avgcost() and lastcost() to not use float

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@1071 4979c152-3d1c-0410-bac9-87ea11338e46
---
 sql/Pg-database.sql | 10 +++++-----
 1 file changed, 5 insertions(+), 5 deletions(-)

diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql
index 525dc405..aae27abc 100644
--- a/sql/Pg-database.sql
+++ b/sql/Pg-database.sql
@@ -1014,12 +1014,12 @@ CREATE TRIGGER del_recurring AFTER DELETE ON ap FOR EACH ROW EXECUTE PROCEDURE d
 CREATE TRIGGER del_recurring AFTER DELETE ON gl FOR EACH ROW EXECUTE PROCEDURE del_recurring();
 -- end trigger
 --
-CREATE FUNCTION avgcost(int) RETURNS FLOAT AS '
+CREATE FUNCTION avgcost(int) RETURNS NUMERIC AS '
 
 DECLARE
 
-v_cost float;
-v_qty float;
+v_cost numeric;
+v_qty numeric;
 v_parts_id alias for $1;
 
 BEGIN
@@ -1046,11 +1046,11 @@ END;
 ' language 'plpgsql';
 -- end function
 --
-CREATE FUNCTION lastcost(int) RETURNS FLOAT AS '
+CREATE FUNCTION lastcost(int) RETURNS numeric AS '
 
 DECLARE
 
-v_cost float;
+v_cost numeric;
 v_parts_id alias for $1;
 
 BEGIN
-- 
cgit v1.2.3