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 round 1.8947 to 1.89 the error is 0.0047. If you round 1.8947 to 1.90 the error is 0.0053. My numbers where 1.49 and the rounding I proposed was: round to 1 decimals, round to 0 decimals to get 2 out of 1.49. I think he is correct and that the postgresql function is also correct. Peter
