diff options
Diffstat (limited to 'sql/dawn.sql')
| -rw-r--r-- | sql/dawn.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 0b485f0f..4815a8c4 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -4172,9 +4172,9 @@ SELECT id, swap_type FROM irs JOIN counterparties ON cp_code = code) ORDER BY trade_date DESC, folder; -CREATE OR REPLACE FUNCTION list_iam(p_date date, p_fund fund) RETURNS TABLE (trade_date date, broker text, clean_folder strategy, start_money numeric(11,2), currency currency, fund fund, folder text) AS $$ BEGIN RETURN QUERY +CREATE OR REPLACE FUNCTION list_iam(p_date date, p_fund fund) RETURNS TABLE (trade_date date, broker text, clean_folder strategy, start_money numeric(11,2), currency currency, fund fund, folder text, portfolio portfolio) AS $$ BEGIN RETURN QUERY SELECT si.date as trade_date, si.broker, si.strategy as clean_strat, si.amount::NUMERIC(11,2), -si.currency, si.fund, COALESCE(pfm.folder::text, strategy::text) AS folder +si.currency, si.fund, COALESCE(pfm.folder::text, strategy::text) AS folder, pfm.portfolio FROM (SELECT *, rank() OVER(PARTITION BY si.broker,si.fund ORDER BY date desc) FROM strategy_im si WHERE si.fund=p_fund AND si.date<=p_date ORDER BY date DESC) si LEFT JOIN portfolio_folder_mapping pfm ON pfm.clean_folder=si.strategy::TEXT @@ -4195,5 +4195,6 @@ CREATE TABLE iams ( is_offset bool NOT NULL, uploaded bool NOT NULL, fund fund NOT NULL, + portfolio portfolio NOT NULL, CONSTRAINT iams_pk PRIMARY KEY (trade_date, strategy, broker, currency, is_offset, fund) );
\ No newline at end of file |