Oracle:
SELECT TRUNC(1.01, 1) FROM DUAL;
结果为 1
Postgre
SELECT TRUNC(1.01, 1);
结果为1.0
区别:Postgre不会把保留的无用0去掉
解决方案
一、SELECT CAST(TRUNC(1.01, 1) AS FLOAT);
二、SELECT TRIM(trailing '0' FROM TRUNC(1.01, 1)::TEXT)::NUMERIC
Oracle:
SELECT TRUNC(1.01, 1) FROM DUAL;
结果为 1
Postgre
SELECT TRUNC(1.01, 1);
结果为1.0
区别:Postgre不会把保留的无用0去掉
解决方案
一、SELECT CAST(TRUNC(1.01, 1) AS FLOAT);
二、SELECT TRIM(trailing '0' FROM TRUNC(1.01, 1)::TEXT)::NUMERIC