On Fri, Aug 19, 2011 at 11:45, Erik Hesselink <[email protected]> wrote:
> 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 [email protected] wandering unix systems administrator (available) (412) 475-9364 vm/sms
_______________________________________________ Haskell-Cafe mailing list [email protected] http://www.haskell.org/mailman/listinfo/haskell-cafe
