Re: math error or rounding problem Money type

<br /><br /> Tom Lane wrote: <blockquote cite="mid:24505.1212877614@sss.pgh.pa.us" type="cite"><pre wrap="">Justin <a
class="moz-txt-link-rfc2396E"href="mailto:justin@emproshunts.com"><justin@emproshunts.com></a> writes:
</pre><blockquotetype="cite"><pre wrap="">I believe i have found a math bug/rounding problem with Money type when 
 
its used with SUM()...  Postgresql 8.3.1   </pre></blockquote><pre wrap="">
You do know that money only stores two fractional digits?
        regards, tom lane </pre></blockquote> yes.  The question is why are the to sides not equal anymore <br /><br />
Takethis <br /><br /> Select <br />     '2',<br />     round(sum( beginBalance ),6) as beginbalance, <br />    
round(sum(negative ),6) as debit, <br />     round(sum( positive ),6) as credit, <br />     round(sum( difference ),6)
asdifference, <br />     round(sum( endbalance),6) as endbalance <br />  from trailbalance <br />  union <br />  Select
<br/>     '1',<br />     sum( round(beginBalance,6)) as beginbalance, <br />     sum( round(negative,6)) as debit, <br
/>    sum( round(positive,6)) as credit, <br />     sum( round(difference,6)) as difference, <br />     sum(
round(endbalance,6))as endbalance <br />  from trailbalance <br /><br /> "1"  -0.000006   -11250546.743752   
11250546.743752  0.000000   -0.000007<br /> "2"   0.000000    -11250546.743752   11250546.743752   0.000000   
0.000000<br/><br /> At the very least this show a clear warning when rounding do it after all the sum function is
callednot before.  <br /><br />