Re: cast numeric with scale and precision to numeric plain

Sim Zacks wrote:
> I'm using 8.2.4
>
>
> Numeric with scale precision always shows the trailing zeros.
>
> Numeric plain only shows numbers after the decimal point that are being
> used.
>
>
> I would like to have the data in my table with scale and precision, but
> my views to be cast to numeric without any scale or precision.
>
> However, when I cast a numeric(16,4) to a ::numeric it doesn't cast it.
>
>
> In order to get the results I want, I have to cast it twice ::double
> precision::numeric and then it removes the trailing zeros.
>
>
> Is there any way to cast directly from numeric with scale and precision
> to plain numeric?


So you already got your answer about why it doesn't work the way you'd
like. But if you are just looking to format it for display you can use
to_char with the FM modifier.

SELECT f1, to_char(f1, 'FM999.0999')
FROM test;
15.0000   15.0
200.0040  200.004
12.4123   12.4123