如何在Postgresql中轻松地将数字UP转换为10的倍数？
例：
In Out 100 --> 100 111 --> 120 123 --> 130
样品数据：
create table sample(mynumber numeric); insert into sample values (100); insert into sample values (111); insert into sample values (123);
我可以用：
select
mynumber,case
when mynumber = round(mynumber,-1) then mynumber
else round(mynumber,-1) + 10 end as result
from
sample;
这样做很好,但看起来很丑陋.有更简单的做法吗？
select ceil(a::numeric / 10) * 10
from (values (100),(111),(123)) s(a);
?column?
----------
100
120
130
