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 8425eaa7..e0700d90 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -1154,7 +1154,7 @@ BEGIN 'securities.coupon, start_accrued_date, settle_date, temp.principal_payment,' 'temp.accrued_payment, securities.currency, securities.day_count, securities.bbg_type, securities.figi ' 'FROM temp LEFT JOIN securities USING (identifier) ' - 'WHERE (temp.notional>0) AND paid_down>$1 %s ' + 'WHERE (temp.notional>0) AND least(paid_down, maturity)>$1 %s ' 'ORDER BY identifier, settle_date desc', trade_or_settle, asset_opt); |