On 3/16/2016 1:07 PM, carlos_penteado(at)yahoo(dot)com(dot)br wrote:
> SELECT 109048.96::float, 0.96::float
> RETURNS
> 109048.96;0.96
> but
> SELECT 109048.96::real, 0.96::real
> RETURNS
> 109049;0.96
float with unspecified precision is treated as double precision. real is
by definition single precision, which is only accurate to around 6 digits.
see http://www.postgresql.org/docs/current/static/datatype-numeric.html
--
john r pierce, recycling bits in santa cruz