Re: NUMERIC's transcendental functions - Mailing list pgsql-hackers

From Tom Lane
Subject Re: NUMERIC's transcendental functions
Date
Msg-id 5011.1032817310@sss.pgh.pa.us
Whole thread Raw
In response to Re: NUMERIC's transcendental functions  (Jan Wieck <JanWieck@Yahoo.com>)
Responses BETA2 HOLD: was Re: NUMERIC's transcendental functions  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: NUMERIC's transcendental functions  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Jan Wieck <JanWieck@Yahoo.com> writes:
> One problem is, that division already has an inherently inexact
> result. Do you intend to rip that out too while at it? (Just
> kidding)

No, but that too is now delivering less precision than it used to:

regression=# select 10.1/7.0;  ?column?
--------------1.4428571429
(1 row)

versus 1.44285714285714 in prior releases.

> Proposal #2.667 would be to have a GUC variable for the default
> precision.

Perhaps, but I'd be satisfied if the default precision were at least
16 digits.  Again, the point is not to have any apparent regression
from 7.2.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Default privileges for 7.3
Next
From: Tom Lane
Date:
Subject: Re: Default privileges for 7.3