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

pgsql-bugs(at)postgresql(dot)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