diff options
Diffstat (limited to 'sql/dawn.sql')
| -rw-r--r-- | sql/dawn.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 10211847..d7faeeda 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -367,9 +367,9 @@ CREATE MATERIALIZED VIEW factors_history AS temp.date-securities.pay_delay AS prev_cpn_date, temp.identifier, temp.principal_bal / securities.face_amount AS factor, - temp.principal / securities.face_amount * 100::double precision AS principal, - temp.interest / securities.face_amount * 100::double precision AS interest, - temp.losses / securities.face_amount * 100::double precision AS losses, + temp.principal / securities.face_amount * 100::float AS principal, + temp.interest / securities.face_amount * 100::float AS interest, + temp.losses / securities.face_amount * 100::float AS losses, COALESCE(temp.coupon, securities.coupon) AS coupon FROM temp JOIN securities USING (identifier); |