--- Tom Lane <[EMAIL PROTECTED]> escreveu: > Clodoaldo Pinto <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster