Postgres Pro
Downloads
Home   >   mailing lists

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

From Bruno Wolff III
Subject Re: Displaying more than six digits from a real number
Date
Msg-id 20041202030730.GA10993@wolff.to
Whole thread Raw
In response to Displaying more than six digits from a real number  (Clodoaldo Pinto <clodoaldo_pinto@yahoo.com.br>)
List pgsql-general
Tree view 
On Wed, Dec 01, 2004 at 20:25:28 -0300,
  Clodoaldo Pinto <clodoaldo_pinto@yahoo.com.br> wrote:
> 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 whithout using to_char() or casting?

I think you can use the extra_float_digits GUC variable to do what you want.

pgsql-general by date:

Previous
From: Joachim Zobel
Date:
Subject: Re: createlang plperl fails with 8.0 beta5
Next
From: Tom Lane
Date:
Subject: Re: Displaying more than six digits from a real number