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)
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/ctypyb2002/p/9793092.html