Re: cast numeric with scale and precision to numeric plain

Sim Zacks <sim@compulab.co.il> writes:
> Numeric with scale precision always shows the trailing zeros.
> Numeric plain only shows numbers after the decimal point that are being
> used.

That statement is false:

regression=# select 1234.000::numeric;
 numeric
----------
 1234.000
(1 row)

I'm not sure offhand what is the easiest way to suppress trailing
zeroes, but casting to plain numeric is not the route to a solution.

Really this is a textual formatting problem.  You might find that the
best bet is something with trim() or a regexp.  The trick would be
not removing zeroes that are significant ...

            regards, tom lane