Hi Tom,
Sorry. After sending to group one friend of mine explained to me how round
works -- not postgresql round, but round in math.
I do not know any software that would produce that output.
I thought that when 1.8947 was rounded to 2 decimal places, 7 would round-up
4, then "5" would round-up
"Fernando Madruga Pinheiro" <[EMAIL PROTECTED]> writes:
> If I use ROUND(1.8947, 2), it should return 1.90, but it does return 1.89.
Why do you consider that wrong? It's the closest approximation.
Do you know of any other software that would produce 1.90 from a
similar query?
> Rounding to 3 dec
On Wed, Jul 11, 2007 at 09:50:25AM -0300, Fernando Madruga Pinheiro wrote:
> Hi. I'm having some strange round behaviour when using 4 decimals.
>
> If I use ROUND(1.8947, 2), it should return 1.90, but it does return 1.89.
I asked my math teacher a similar question back in 7th grade:
If you ro
