diff options
Diffstat (limited to 'sql/dawn.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 2b3ff3e9..03236419 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -1075,7 +1075,7 @@ SELECT as_of_date, substring(security_description_1 FROM '(IG|HY|EU|XO)')::index (CASE WHEN coupon_rate=0 THEN current_notional ELSE -current_notional END) AS admin_notional, sum(base_market_value) OVER w as admin_clean_nav, row_number() OVER w -FROM bowdst_val WHERE security_description_1 LIKE 'CCP%' +FROM bowdst_val WHERE security_description_1 LIKE '%CCP%' WINDOW w AS (PARTITION BY substring(security_description_1 FROM '(IG|HY|EU|XO)')::index_type, substring(security_description_1 FROM '(?:IG|HY|EUR|XOVER)(?:\.| )([0-9]{2})')::smallint, maturity_date) |