diff options
Diffstat (limited to 'sql/dawn.sql')
| -rw-r--r-- | sql/dawn.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index d0941f34..af2667b0 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -1105,7 +1105,7 @@ CREATE OR REPLACE function list_positions(p_date date, p_fund fund DEFAULT 'SERCGMAST'::fund) RETURNS TABLE(identifier varchar(12), description varchar(32), notional float, strategy strategy, curr_cpn float, start_accrued_date date, last_settle_date date, - principal_payment float, accrued_payment float, currency currency, daycount day_count, + principal_payment numeric(11, 2), accrued_payment numeric(11, 2), currency currency, daycount day_count, bbg_type bbg_type, figi varchar(12)) AS $$ DECLARE sqlquery text; DECLARE asset_opt text; @@ -1146,7 +1146,7 @@ CREATE OR REPLACE function list_positions_range(start_date date, p_class asset_class DEFAULT NULL) RETURNS TABLE(identifier varchar(12), description varchar(32), notional float, strategy bond_strat, curr_cpn float, start_accrued_date date, last_settle_date date, - principal_payment float, accrued_payment float, currency currency, daycount day_count, + principal_payment numeric(11, 2), accrued_payment numeric(11, 2), currency currency, daycount day_count, bbg_type bbg_type) AS $$ DECLARE sqlquery text; DECLARE asset_opt text; @@ -1174,8 +1174,8 @@ CREATE OR REPLACE function risk_positions(p_date date, include_unsettled boolean DEFAULT True) RETURNS TABLE (description varchar(32), identifier varchar(12), notional float, price float, strategy strategy, factor float, local_market_value float, usd_market_value float, -curr_cpn float, int_acc float, last_pay_date date, principal_payment float, -accrued_payment float, last_settle_date date, figi varchar(12)) AS $$ +curr_cpn float, int_acc float, last_pay_date date, principal_payment numeric(11, 2), +accrued_payment numeric(11, 2), last_settle_date date, figi varchar(12)) AS $$ BEGIN RETURN QUERY SELECT a.description, a.identifier, a.notional, c.price, a.strategy, coalesce(b.factor, 1), |