Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Displaying more than six digits from a real number
Date
Msg-id 1759.1101956371@sss.pgh.pa.us
Whole thread Raw
In response to Displaying more than six digits from a real number  (Clodoaldo Pinto <clodoaldo_pinto@yahoo.com.br>)
Responses Re: Displaying more than six digits from a real number
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Displaying more than six digits from a real number
Next
From: Bruno Wolff III
Date:
Subject: Re: data integrity and inserts