postgreSQL 数据库基础 除法保留小数位如何设置的实例

我就废话不多说了，大家还是直接看代码吧~

x
select 8/(100-3) as c1,
round(8/(100-3) ,4) as c2,
round(8/(100-3)::numeric ,4) as c3,
8/(100-3)::numeric as c4
;
-[ RECORD 1 ]————–
c1 | 0
c2 | 0.0000
c3 | 0.0825
c4 | 0.08247422680412371134
(1 row)