Displaying more than six digits from a real number

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

On Wed, Dec 01, 2004 at 20:25:28 -0300,
Clodoaldo Pinto <clodoaldo_pinto@yahoo.com.br> wrote:

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?

I think you can use the extra_float_digits GUC variable to do what you want.

 --- Tom Lane <tgl@sss.pgh.pa.us> escreveu: 

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.)

That is exactly what I wanted. Yes, I'm aware. But I wonder how is the 7th
digit right? At least with the few tests I did it was never wrong.

I will have to change that column to float8 but for now it is good enough.

Thanks

 --- Bruno Wolff III <bruno@wolff.to> escreveu: 

I think you can use the extra_float_digits GUC variable to do what you want.

Regards,
Clodoaldo Pinto

_______________________________________________________
Yahoo! Acesso Gr�tis - Internet r�pida e gr�tis. Instale o discador agora! http://br.acesso.yahoo.com/