19 Aug
2011
19 Aug
'11
4:11 p.m.
On Fri, Aug 19, 2011 at 11:45, Erik Hesselink
Note that PostgreSQL also doesn't work with decimals as precision:
postgres=# select 1::decimal(4,2) * 1::decimal(4,2); ?column? ---------- 1.0000 (1 row)
That should be 1.00 instead if you want the precision correctly represented.
Er? Last I checked, that was exactly how precision worked over multiplication; otherwise you are incorrectly discarding precision present in the original values. Unless you're assuming the OP actually wants an incorrect flat precision model.... -- brandon s allbery allbery.b@gmail.com wandering unix systems administrator (available) (412) 475-9364 vm/sms