Re: Bug #878: different format of float values in 7.2.and

On Mon, 20 Jan 2003 03:13:38 -0500 (EST)
pgsql-bugs(at)postgresql(dot)org 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.0
>
> produces different results. In 7.2.3 it is:
>
> ?column?
> ---------------------
> 1.875
>
> while in 7.3.1 it is:
>
> ?column?
> ---------------------
> 1.87500000000000000

qurczak=# SELECT 1875::float/1000.0;
?column?
----------
1.875
(1 row)

qurczak=# SELECT (1875/1000.0)::float;
float8
--------
1.875
(1 row)

It works ;] You try something this int/float = yee khmm but
int::float/float= float, or something like this ;]

--
"Nieobecni nie mają racji"

Marcin Winkler