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/
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/