Re: Displaying more than six digits from a real number

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 02:59:31
Message-ID: 1759.1101956371@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Clodoaldo Pinto <clodoaldo_pinto(at)yahoo(dot)com(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2004-12-02 03:07:30 Re: Displaying more than six digits from a real number
Previous Message Eric E 2004-12-02 02:34:28 Pl/Perl w/ Postgres 8.0 on Windows