From 6691d7ee9ff7ef2b97309c0d0709473ff82b8167 Mon Sep 17 00:00:00 2001 From: erickson Date: Tue, 19 Feb 2008 22:11:53 +0000 Subject: [PATCH] added stored proc to return the calculated amount based on exchange rates between two currencies git-svn-id: svn://svn.open-ils.org/ILS/branches/acq-experiment@8782 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/200.schema.acq.sql | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/Open-ILS/src/sql/Pg/200.schema.acq.sql b/Open-ILS/src/sql/Pg/200.schema.acq.sql index 82318a0b94..7b3067c160 100644 --- a/Open-ILS/src/sql/Pg/200.schema.acq.sql +++ b/Open-ILS/src/sql/Pg/200.schema.acq.sql @@ -325,6 +325,10 @@ BEGIN END; $$ LANGUAGE PLPGSQL; +CREATE OR REPLACE FUNCTION acq.exchange_ratio ( TEXT, TEXT, NUMERIC ) RETURNS NUMERIC AS $$ + SELECT $3 * acq.exchange_ratio($1, $2); +$$ LANGUAGE SQL; + CREATE OR REPLACE VIEW acq.funding_source_credit_total AS SELECT funding_source, SUM(amount) AS amount -- 2.11.0