On Mon, 20 Jan 2003, Tom Lane wrote:
TL> [EMAIL PROTECTED] writes:
TL> > The following line:
TL> > SELECT 1875/1000.0
TL> > produces different results. In 7.2.3 it is:
TL> > ?column?
TL> > -
TL> >1.875
TL>
TL> > while in 7.3.1 it is:
TL> > ?column?
TL> > ---
On Mon, 20 Jan 2003 03:13:38 -0500 (EST)
[EMAIL PROTECTED] wrote:
> strings without any unnecessary padding zeroes. I use a usual
> postgresql*-7.3.1-1PGDG.i386.rpm taken from your site, if it makes
> sense. Please take a look into this.
>
> Sample Code
> The following line:
>
> SELECT 1875/1000
[EMAIL PROTECTED] writes:
> The following line:
> SELECT 1875/1000.0
> produces different results. In 7.2.3 it is:
> ?column?
> -
>1.875
> while in 7.3.1 it is:
> ?column?
> -
> 1.87500
The above expression is
Denis N.Stepanov ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
different format of float values in 7.2.and 7.3
Long Description
There is a difference in return value of some floating point operations in PostgreSQL
7.2 and 7.3
