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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Russell Smith <russell(at)pws(dot)com(dot)au>
Cc: "Roman Schayuk" <rschayuk(at)rogers(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1577: round(dp) function does not round to nearest integer properly
Date: 2005-04-11 06:03:37
Message-ID: 22067.1113199417@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Russell Smith <russell(at)pws(dot)com(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-04-11 06:07:46 Re: BUG #1580: pg_dumpall aborts when cwd is unreadable
Previous Message Tom Lane 2005-04-11 05:51:57 Re: BUG #1584: undefined symbol _tas