[Haskell-cafe] custom SQL-to-Haskell type conversion in HDBC

[Brandon Allbery]

On Fri, Aug 19, 2011 at 11:45, Erik Hesselink <hesselink at gmail.com> 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                                      allbery.b at gmail.com
wandering unix systems administrator (available)     (412) 475-9364 vm/sms
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.haskell.org/pipermail/haskell-cafe/attachments/20110819/6f4404b5/attachment.htm>