From a5b4492c809c787c61f613e08ac2ed46f67cf8b4 Mon Sep 17 00:00:00 2001 From: linuxpoet 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