From b813d143aec23aeb89dd9ebc73bfeda2dfc622fe Mon Sep 17 00:00:00 2001
From: Tom Lane
Date: Wed, 2 Oct 2002 19:21:26 +0000
Subject: 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.

---
 src/test/regress/expected/aggregates.out | 18 +++++++++---------
 1 file changed, 9 insertions(+), 9 deletions(-)

(limited to 'src/test')

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;
-- 
cgit v1.2.3