diff options
Diffstat (limited to 'sql/dawn.sql')
| -rw-r--r-- | sql/dawn.sql | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index e8312495..af28a7ce 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -167,7 +167,11 @@ NEW.portfolio = ( CASE WHEN NEW.folder::text LIKE '%MTG%' THEN 'MORTGAGES' WHEN NEW.folder::TEXT LIKE '%CLO%' THEN 'CLO' WHEN NEW.folder::TEXT LIKE '%CRT%' THEN 'MORTGAGES' -WHEN NEW.folder::TEXT LIKE '%STR%' THEN 'STRUCTURED' END)::portfolio; +WHEN NEW.folder::TEXT LIKE '%STR%' THEN 'STRUCTURED' +WHEN NEW.folder::TEXT='M_CSH_CASH' THEN 'CASH' +WHEN NEW.folder::TEXT='TCSH' THEN 'TRANCHE' +WHEN NEW.folder::TEXT='SER_ITRXCURVE' THEN 'CURVE' +LIKE END)::portfolio; RETURN NEW; END $$ LANGUAGE plpgsql; |