diff options
| author | Tom Lane | 2002-10-02 19:21:26 +0000 |
|---|---|---|
| committer | Tom Lane | 2002-10-02 19:21:26 +0000 |
| commit | b813d143aec23aeb89dd9ebc73bfeda2dfc622fe (patch) | |
| tree | 2b8b6b84f1d5ff81e98503768db91ea05ae5c394 /src/test | |
| parent | c74c7e604cb739ce3c5821d88f8328b5b2a233c3 (diff) | |
Alter scale selection for NUMERIC division and transcendental functions
so that precision of result is always at least as good as you'd get from
float8 arithmetic (ie, always at least 16 digits of accuracy). Per
pg_hackers discussion a few days ago.
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/aggregates.out | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/src/test/regress/expected/aggregates.out b/src/test/regress/expected/aggregates.out index aaee72c01a..7519f6e539 100644 --- a/src/test/regress/expected/aggregates.out +++ b/src/test/regress/expected/aggregates.out @@ -2,15 +2,15 @@ -- AGGREGATES -- SELECT avg(four) AS avg_1 FROM onek; - avg_1 --------------- - 1.5000000000 + avg_1 +--------------------- + 1.50000000000000000 (1 row) SELECT avg(a) AS avg_32 FROM aggtest WHERE a < 100; - avg_32 ---------------- - 32.6666666667 + avg_32 +-------------------- + 32.666666666666667 (1 row) -- In 7.1, avg(float4) is computed using float8 arithmetic. @@ -118,9 +118,9 @@ select ten, count(four), sum(DISTINCT four) from onek group by ten; (10 rows) SELECT newavg(four) AS avg_1 FROM onek; - avg_1 --------------- - 1.5000000000 + avg_1 +--------------------- + 1.50000000000000000 (1 row) SELECT newsum(four) AS sum_1500 FROM onek; |