diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index f94621ad..c4b138ab 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -4175,8 +4175,8 @@ FROM irs JOIN counterparties ON cp_code = code) ORDER BY trade_date DESC, folder CREATE OR REPLACE FUNCTION compare_globeop_quotes(p_date date, p_fund fund) RETURNS TABLE (identifier TEXT, maturity date, INDEX index_type, security_desc TEXT, serenitas_quote NUMERIC(6,2), globeop_quote NUMERIC(6,2)) AS $$ BEGIN RETURN QUERY -SELECT a.security_id::text, a.maturity::date, a.INDEX, a.security_desc::text, price::NUMERIC(6,2), endlocalmarketprice::numeric(6,2) FROM list_cds_marks(p_date, NULL, p_fund) a LEFT JOIN (SELECT +SELECT a.security_id::text, a.maturity::date, a.INDEX, a.security_desc::text, price::NUMERIC(6,2), endlocalmarketprice::numeric(6,2) FROM list_cds_marks(p_date, NULL, p_fund) a LEFT JOIN (SELECT DISTINCT endlocalmarketprice::NUMERIC(6,2), i.security_id, i.maturity FROM (SELECT endlocalmarketprice , split_part(invid, '_', 2) AS security_id, split_part(invid, '_', 6)::date AS maturity - FROM valuation_reports WHERE invid LIKE 'CDS\_%%' AND periodenddate =p_date AND fund= p_fund) b USING (security_id, maturity); END $$ LANGUAGE plpgsql;
\ No newline at end of file + FROM valuation_reports WHERE invid LIKE 'CDS\_%%' AND periodenddate =p_date AND fund= p_fund) i)b USING (security_id, maturity); END $$ LANGUAGE plpgsql;
\ No newline at end of file |