diff options
| author | Bruce Momjian | 2007-02-17 00:55:58 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2007-02-17 00:55:58 +0000 |
| commit | 89a624439eb0ac15f99f20397b6bdf0150e1900d (patch) | |
| tree | a3aa22469d1f133fc5ee5398085d76040fff78c1 /src/test | |
| parent | 72a070a3653ffc6519b9af5f3959f872cb4dea7d (diff) | |
Create AVG() aggregates for int8 and NUMERIC which do not compute X^2,
as a performance enhancement.
Mark Kirkwood
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/create_aggregate.out | 6 | ||||
| -rw-r--r-- | src/test/regress/sql/create_aggregate.sql | 6 |
2 files changed, 6 insertions, 6 deletions
diff --git a/src/test/regress/expected/create_aggregate.out b/src/test/regress/expected/create_aggregate.out index 08daaa8ee3..1c540b2d95 100644 --- a/src/test/regress/expected/create_aggregate.out +++ b/src/test/regress/expected/create_aggregate.out @@ -3,9 +3,9 @@ -- -- all functions CREATEd CREATE AGGREGATE newavg ( - sfunc = int4_accum, basetype = int4, stype = _numeric, - finalfunc = numeric_avg, - initcond1 = '{0,0,0}' + sfunc = int4_avg_accum, basetype = int4, stype = _int8, + finalfunc = int8_avg, + initcond1 = '{0,0}' ); -- test comments COMMENT ON AGGREGATE newavg_wrong (int4) IS 'an agg comment'; diff --git a/src/test/regress/sql/create_aggregate.sql b/src/test/regress/sql/create_aggregate.sql index 891b0e0892..9d02048e24 100644 --- a/src/test/regress/sql/create_aggregate.sql +++ b/src/test/regress/sql/create_aggregate.sql @@ -4,9 +4,9 @@ -- all functions CREATEd CREATE AGGREGATE newavg ( - sfunc = int4_accum, basetype = int4, stype = _numeric, - finalfunc = numeric_avg, - initcond1 = '{0,0,0}' + sfunc = int4_avg_accum, basetype = int4, stype = _int8, + finalfunc = int8_avg, + initcond1 = '{0,0}' ); -- test comments |