Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #1577: round(dp) function does not round to nearest integer properly - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1577: round(dp) function does not round to nearest integer properly
Date
Msg-id 22067.1113199417@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #1577: round(dp) function does not round to nearest integer properly  (Russell Smith <russell@pws.com.au>)
List pgsql-bugs
Tree view 
Russell Smith <russell@pws.com.au> 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).

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #1584: undefined symbol _tas
Next
From: Tom Lane
Date:
Subject: Re: BUG #1580: pg_dumpall aborts when cwd is unreadable