diff options
| -rw-r--r-- | sql/et_tables.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/et_tables.sql b/sql/et_tables.sql index 3d674c59..d3f01ffc 100644 --- a/sql/et_tables.sql +++ b/sql/et_tables.sql @@ -428,7 +428,7 @@ CREATE OR REPLACE FUNCTION et_aggdealinfo_historical (p_dealname varchar(10), p_ BEGIN RETURN QUERY SELECT a.issuername, sum(a.currentbalance) AS currentbalance, a.maturity, a.fixedorfloat, max(a.assettype), - avg(coalesce((b.bid+b.offer)/2, c.price)) AS price, + avg(coalesce((b.bid+b.offer)/2, c.price, a.intexprice)) AS price, avg(a.grosscoupon) AS grosscoupon, avg(a.spread) AS spread, a.frequency, min(a.nextpaydate) AS nextpaydate, a.loanxid, a.cusip, (max(a.covlite)='Cov_Lite' or (max(a.covlite)='COV_LITE' or |