Re: Displaying more than six digits from a real number

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Clodoaldo Pinto <clodoaldo_pinto(at)yahoo(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Displaying more than six digits from a real number
Date: 2004-12-02 03:07:30
Message-ID: 20041202030730.GA10993@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Dec 01, 2004 at 20:25:28 -0300,
Clodoaldo Pinto <clodoaldo_pinto(at)yahoo(dot)com(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2004-12-02 04:10:01 Re: Upcoming Changes to News Server ...
Previous Message Tom Lane 2004-12-02 02:59:31 Re: Displaying more than six digits from a real number