Displaying more than six digits from a real number - Mailing list pgsql-general

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/