diff options
Diffstat (limited to 'python/Dawn/utils.py')
| -rw-r--r-- | python/Dawn/utils.py | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/python/Dawn/utils.py b/python/Dawn/utils.py index 3a8757e7..a6caf558 100644 --- a/python/Dawn/utils.py +++ b/python/Dawn/utils.py @@ -59,7 +59,8 @@ def add_triggers(engine): CREATE OR REPLACE FUNCTION mydealid() RETURNS TRIGGER AS $$ BEGIN - UPDATE bonds SET dealid = 'SC_' ||upper(left(asset_class::text,3))||id WHERE bonds.id = NEW.id; + UPDATE bonds SET dealid = 'SC_' ||upper(left(asset_class::text,3))||id, + identifier = COALESCE(identifier, cusip, isin) WHERE bonds.id = NEW.id; RETURN NEW; END; $$ language plpgsql""")) |