postgresql对字符串格式化成整数最多2位小数最多两位

trim(trailing '.' from trim(trailing '0' from cast(zyyzzx.ypsycjl as numeric(4,2))::text))

参考：

https://vimsky.com/examples/usage/postgresql-trim-function.html

https://qa.1r1g.com/sf/ask/2361137691/