diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/et_tables.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/sql/et_tables.sql b/sql/et_tables.sql index 2eec3eec..dc8a47a3 100644 --- a/sql/et_tables.sql +++ b/sql/et_tables.sql @@ -583,13 +583,13 @@ ALTER FUNCTION et_aggdealinfo_historical(varchar(10), date) OWNER TO et_user; CREATE OR REPLACE FUNCTION et_cusip_details(p_cusips VARIADIC varchar(10)[]) - RETURNS TABLE(orig_moody text, curr_moody text, empty1 unknown, issuer text, - manager text, empty2 unknown, spread float, coupon float, issuedate date, + RETURNS TABLE(orig_moody text, curr_moody text, empty1 text, issuer text, + manager text, empty2 text, spread float, coupon float, issuedate date, reinvenddate date, maturity date, stale_percentage float, cdo_percentage float, wap_basis float, portfolio_spread_5y float, portfolio_spread float, subordination float, thickness float, mvoc float, mvcoverage float, - empty3 unknown, pricingdate date, delta float, duration float, wal float, price float) AS $$ + empty3 text, pricingdate date, delta float, duration float, wal float, price float) AS $$ BEGIN RETURN QUERY SELECT a.Orig_Moody, a.Curr_Moody, NULL, b."Deal Name", b.manager, NULL, a.Spread/100, a.Coupon/100, b.deal_issue_date, b.reinv_end_date, b.Maturity, |