Hi,
I want to remove not needed decimal places / trailing zeros from a numeric.
I know this can be done starting PG >=13 with TRIM_SCALE(numeric) which would
solve my issue (with an additional CAST to TEXT at the end).
Unfortunately the production database is still running with PostgreSQL 12.x an
Hello Erik,
many thanks for the feedback (Oracle) and the second option to get rid of the
decimal separator character.
The case is closed.
Kind regards
Juergen
> Gesendet: Mittwoch, 15. März 2023 um 17:50 Uhr
> Von: "Erik Wienhold"
> An: magog...@web.de, pgsql-general@lists.postgresql.org
> B
