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