From: | Sim Zacks <sim(at)compulab(dot)co(dot)il> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | cast numeric with scale and precision to numeric plain |
Date: | 2009-10-19 16:03:24 |
Message-ID: | 4ADC8DCC.4080609@compulab.co.il |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-10-19 16:07:03 | Re: autovacuum and immediate shutdown issues |
Previous Message | Brad Nicholson | 2009-10-19 15:53:59 | autovacuum and immediate shutdown issues |