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).
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
"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
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: