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

From Clodoaldo Pinto
Subject Re: Displaying more than six digits from a real number
Date
Msg-id 20041202095358.71008.qmail@web40910.mail.yahoo.com
Whole thread Raw
In response to Re: Displaying more than six digits from a real number  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
 --- 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/

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Get diagnistic (row_count) 7.3 vs. 7.4 changes
Next
From: Richard Huxton
Date:
Subject: Re: md5 checksum mismatch