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

On Mon, 20 Jan 2003 03:13:38 -0500 (EST)
pgsql-bugs@postgresql.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