diff options
Diffstat (limited to 'sql/serenitasdb.sql')
| -rw-r--r-- | sql/serenitasdb.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql index 25ce6006..ca45551c 100644 --- a/sql/serenitasdb.sql +++ b/sql/serenitasdb.sql @@ -432,7 +432,8 @@ RETURNS SETOF cds_issuers AS $$ JOIN bbg_markit_mapping b
ON a.company_id = b.company_id AND a.latestdate=b.date) map
JOIN bbg_issuers USING (company_id)
- LEFT JOIN defaulted ON map.company_id = id;
+ LEFT JOIN (SELECT * FROM defaulted WHERE event_date <= $1 ) c
+ ON map.company_id = id;
END;
$$ LANGUAGE plpgsql;
|