1 files changed, 9 insertions, 4 deletions
diff --git a/sql/et_tables.sql b/sql/et_tables.sql
index 9deaae6c..e1d6686c 100644
--- a/sql/et_tables.sql
+++ b/sql/et_tables.sql
@@ -374,7 +374,11 @@ CREATE OR REPLACE FUNCTION historical_markit_prices(p_date date)
        $$ LANGUAGE plpgsql;
 
 CREATE OR REPLACE FUNCTION historical_bloomberg_corp(p_date date)
-  RETURNS TABLE(cusip character varying, price double precision, pricingdate date, issuer text, maturity date, coupon double precision, coupontype bloomberg_cpntype, frequency integer, spread double precision, libor_floor double precision, loan_margin double precision, covlite boolean, secondlien boolean, defaulted boolean, source bloomberg_source) AS
+  RETURNS TABLE(cusip character varying, price double precision, pricingdate date,
+  issuer text, maturity date, coupon double precision, coupontype bloomberg_cpntype,
+  frequency integer, spread double precision, libor_floor double precision,
+  loan_margin double precision, covlite boolean, secondlien boolean,
+  defaulted boolean, source bloomberg_source) AS
 $BODY$
        BEGIN
        RETURN QUERY SELECT b.* FROM
@@ -399,9 +403,10 @@ $BODY$
 
 CREATE OR REPLACE FUNCTION et_aggdealinfo_historical (p_dealname varchar(10), p_date date)
        RETURNS TABLE(issuername text, currentbalance float, maturity date,
-       fixedorfloat intex_fixedorfloat, assettype text, price float, grosscoupon float, spread float,
-       frequency varchar(1), nextpaydate date, loanxid varchar(10), cusip varchar(9),
-       covlite boolean, secondlien boolean, iscdo boolean, defaultedflag boolean, et_loanxid varchar(10), et_cusip varchar(9)) AS $$
+       fixedorfloat intex_fixedorfloat, assettype text, price float, grosscoupon float,
+       spread float, frequency varchar(1), nextpaydate date, loanxid varchar(10),
+       cusip varchar(9), covlite boolean, secondlien boolean, iscdo boolean, defaultedflag boolean,
+       et_loanxid varchar(10), et_cusip varchar(9)) AS $$
        BEGIN
 	RETURN QUERY SELECT a.issuername, sum(a.currentbalance) AS
 	currentbalance, a.maturity, a.fixedorfloat, max(a.assettype),