diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 2e1e3d41..dc618b99 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -1684,7 +1684,7 @@ USING (security_id, maturity)', and_clause); -- ELSIF p_fund = 'BOWDST' THEN -- sqlquery := 'SELECT a.*, bowdst_index.admin_clean_nav, bowdst_index.admin_notional FROM list_cds_marks_pre($1, $2, $3) a LEFT JOIN bowdst_index USING (p_index, p_series, maturity) WHERE as_of_date=$1'; ELSIF p_fund = 'BRINKER' THEN -sqlquery := 'SELECT *, 0::double precision, 0::double precision FROM list_cds_marks_pre($1, $2, $3)'; +sqlquery := 'SELECT *, 0::double precision, 0::double precision, 0::double precision, 0::numeric(6,2) FROM list_cds_marks_pre($1, $2, $3)'; ELSIF p_fund = 'ISOSEL' THEN sqlquery := format(' SELECT l.*, b.dirty_nav, b.position, 100 - ((b.dirty_nav-l.accrued)/(b.position*(factor/100)))::numeric(6,2) FROM list_cds_marks_pre($1, $2, $3) l |