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? example: create table test(f1 numeric(16,4)); insert into test(f1)values(15),(200.004),(12.4123); select f1 from test; 15.0000 200.0040 12.4123 select f1::numeric from test 15.0000 200.0040 12.4123 select f1::float::numeric from test 15 200.004 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
