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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
