Re: Bug #878: different format of float values in 7.2.and 7.3 - Mailing list pgsql-bugs

pgsql-bugs@postgresql.org 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.87500000000000000

The above expression is taken as NUMERIC datatype in 7.3, rather than
FLOAT8 as it was in 7.2.  To get the same output as before, try
    SELECT 1875/1000.0::float8;

            regards, tom lane