diff options
| -rw-r--r-- | sql/et_tables.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/et_tables.sql b/sql/et_tables.sql index 5fd4ff78..d0ec4bd4 100644 --- a/sql/et_tables.sql +++ b/sql/et_tables.sql @@ -302,7 +302,7 @@ CREATE OR REPLACE FUNCTION et_historicaldealinfo (p_dealname varchar(10), p_date et_cusip varchar(10), intexprice float, intexpricesource text, intexpricedate date, userprice float, userpricedate date, fixedorfloat intex_fixedorfloat, defaultedflag boolean, covlite text, iscdo boolean, liborfloor float, - reinvflag boolean) AS $$ + reinvflag boolean, currency varchar(3)) AS $$ DECLARE latestdate date; BEGIN SELECT max(et_collateral.updatedate) INTO latestdate FROM et_collateral @@ -321,7 +321,7 @@ CREATE OR REPLACE FUNCTION et_latestdealinfo (p_dealname varchar(10)) et_cusip varchar(10), intexprice float, intexpricesource text, intexpricedate date, userprice float, userpricedate date, fixedorfloat intex_fixedorfloat, defaultedflag boolean, covlite text, iscdo boolean, liborfloor float, - reinvflag boolean) AS $$ + reinvflag boolean, currency varchar(3)) AS $$ DECLARE latestdate date; BEGIN SELECT max(et_collateral.updatedate) INTO latestdate FROM et_collateral |