diff options
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/aggregates.out | 18 | ||||
| -rw-r--r-- | src/test/regress/expected/numeric.out | 6 |
2 files changed, 12 insertions, 12 deletions
diff --git a/src/test/regress/expected/aggregates.out b/src/test/regress/expected/aggregates.out index 5a628755190..9378ce7c9bc 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.50000000000000000 + avg_1 +-------------------- + 1.5000000000000000 (1 row) SELECT avg(a) AS avg_32 FROM aggtest WHERE a < 100; - avg_32 --------------------- - 32.666666666666667 + avg_32 +--------------------- + 32.6666666666666667 (1 row) -- In 7.1, avg(float4) is computed using float8 arithmetic. @@ -120,9 +120,9 @@ group by ten order by ten; (10 rows) SELECT newavg(four) AS avg_1 FROM onek; - avg_1 ---------------------- - 1.50000000000000000 + avg_1 +-------------------- + 1.5000000000000000 (1 row) SELECT newsum(four) AS sum_1500 FROM onek; diff --git a/src/test/regress/expected/numeric.out b/src/test/regress/expected/numeric.out index d1797df4903..50730edcf8f 100644 --- a/src/test/regress/expected/numeric.out +++ b/src/test/regress/expected/numeric.out @@ -665,9 +665,9 @@ SELECT t1.id1, t1.result, t2.expected -- ****************************** -- numeric AVG used to fail on some platforms SELECT AVG(val) FROM num_data; - avg ----------------------- - -13430913.5922423207 + avg +------------------------ + -13430913.592242320700 (1 row) -- Check for appropriate rounding and overflow |