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)
posted @ 2017-12-08 14:58  peiybpeiyb  阅读(2117)  评论(0)  编辑  收藏  举报