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