The 7.4.2 manual says the precision of a real number is 6 decimal digits.
Is it possible to force the display of more than six decimal digits of a real
number whithout using to_char() or casting?
Using 7.4.2, FC2.
create table test (f4 float4) without oids;
insert into test values (4877852);
select f4, to_char(f4, 'FM9999999'), cast(f4 as int)
from test;
f4 | to_char | f4
-------------+---------+---------
4.87785e+06 | 4877852 | 4877852
Clodoaldo Pinto
_______________________________________________________
Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador agora! http://br.acesso.yahoo.com/