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

Clodoaldo Pinto <clodoaldo_pinto@yahoo.com.br> writes:
> 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

Perhaps the extra_float_digits runtime parameter is what you want?
(You are of course aware that there aren't really more than six
useful digits there... or if you're not, maybe you should stay away
from float and use numeric.)

            regards, tom lane