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 844df7a7..dcc90ad6 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -1071,7 +1071,7 @@ CREATE OR REPLACE VIEW bowdst_index AS SELECT as_of_date, substring(security_description_1 FROM '(IG|HY|EU|XO)')::index_type AS p_index, - substring(security_description_1 FROM '(?:IG|HY|EUR|XOVER)\.([0-9]{2})')::smallint as p_series, + substring(security_description_1 FROM '(?:IG|HY|EUR|XOVER)(?:\.| )([0-9]{2})')::smallint as p_series, maturity_date AS maturity, (CASE WHEN coupon_rate=0 THEN current_notional ELSE -current_notional END) AS admin_notional, base_market_value AS admin_clean_nav |