Skip site navigation (1) Skip section navigation (2)

Re: float output precision questions

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Pedro M(dot) Ferreira" <pfrazao(at)ualg(dot)pt>,Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>,Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: float output precision questions
Date: 2002-10-31 23:33:28
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
On Thu, Oct 31, 2002 at 12:58:21 -0500,
  Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> But I think an EXTRA_DIGITS setting might be interesting.  In
> particular, suppose we allowed EXTRA_DIGITS to be negative?  Setting
> it to -1 or -2 would go a long way towards eliminating our problems
> with platform variations in the geometry regression test.

My attempt to avoid this problem with the earthdistance regression used
a cast to numeric to limit the number of digits to the right of the
decimal point.

If the normal number of digits displayed is different between two systems,
than displaying a fixed number less digits is still going to result in

In response to


pgsql-hackers by date

Next:From: Tom LaneDate: 2002-10-31 23:55:03
Subject: Re: float output precision questions
Previous:From: Tom LaneDate: 2002-10-31 22:07:28
Subject: Re: pg_dump and large files - is this a problem?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group