[EMAIL PROTECTED] 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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
