Re: Displaying more than six digits from a real number
От | Clodoaldo Pinto |
---|---|
Тема | Re: Displaying more than six digits from a real number |
Дата | |
Msg-id | 20041202095358.71008.qmail@web40910.mail.yahoo.com обсуждение исходный текст |
Ответ на | Re: Displaying more than six digits from a real number (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | 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 по дате отправления: