ists.postgresql.org
> Betreff: Re: Removing trailing zeros (decimal places) from a numeric (pre
> trim_scale()) with unexpected behaviour
>
> > On 15/03/2023 14:51 CET magog...@web.de wrote:
> >
> > I want to remove not needed decimal places / trailing zeros from a numeric
> On 15/03/2023 14:51 CET magog...@web.de wrote:
>
> 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 produc
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