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 по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Get diagnistic (row_count) 7.3 vs. 7.4 changes
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: md5 checksum mismatch