Re: [BUGS] BUG #1577: round(dp) function does not round to nearest integer properly

2005-04-10 Thread Tom Lane
Russell Smith <[EMAIL PROTECTED]> writes: > Either way 8.0.1 round differently; The rounding is the same. The difference from 7.2 is that the unadorned literal "42.5" is now considered to be numeric whereas 7.2 treated it as float8. This changed quite some time ago (in 7.3 it looks like).

Re: [BUGS] BUG #1577: round(dp) function does not round to nearest integer properly

2005-04-10 Thread Russell Smith
On Mon, 11 Apr 2005 05:57 am, Tom Lane wrote: > "Roman Schayuk" <[EMAIL PROTECTED]> writes: > > gap=> select round(42.5); > > round > > --- > > 42 > > (1 row) > > Result has to be 43 > > No, the above is perfectly correct and in fact required by the IEEE > standard for floating-point arit

Re: [BUGS] BUG #1577: round(dp) function does not round to nearest integer properly

2005-04-10 Thread Tom Lane
"Roman Schayuk" <[EMAIL PROTECTED]> writes: > gap=> select round(42.5); > round > --- > 42 > (1 row) > Result has to be 43 No, the above is perfectly correct and in fact required by the IEEE standard for floating-point arithmetic (because round-to-nearest-even is the default rounding mode

[BUGS] BUG #1577: round(dp) function does not round to nearest integer properly

2005-04-10 Thread Roman Schayuk
The following bug has been logged online: Bug reference: 1577 Logged by: Roman Schayuk Email address: [EMAIL PROTECTED] PostgreSQL version: 7.2.2 Operating system: RedHat Linux 8.0 x86 Description:round(dp) function does not round to nearest integer properly Details: