summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/Pg-database.sql10
1 files 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