diff options
| author | Marc G. Fournier <scrappy@hub.org> | 1997-04-06 06:07:13 +0000 |
|---|---|---|
| committer | Marc G. Fournier <scrappy@hub.org> | 1997-04-06 06:07:13 +0000 |
| commit | 588ae64c4402ddf6e9fc8596fa2c53453d577f73 (patch) | |
| tree | 2146a1b123d3c37bff7aa2b76100acdb54c40db8 /src/test/regress/sql/create_aggregate.sql | |
| parent | 063190a5fa15d1f392cd7c5c314b342df7adec75 (diff) | |
| download | postgresql-588ae64c4402ddf6e9fc8596fa2c53453d577f73.tar.gz | |
More splits and cleanups...
Diffstat (limited to 'src/test/regress/sql/create_aggregate.sql')
| -rw-r--r-- | src/test/regress/sql/create_aggregate.sql | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/src/test/regress/sql/create_aggregate.sql b/src/test/regress/sql/create_aggregate.sql new file mode 100644 index 0000000000..79b3b02b8d --- /dev/null +++ b/src/test/regress/sql/create_aggregate.sql @@ -0,0 +1,26 @@ +-- +-- AGGREGATE DEFINITIONS +-- + +-- all functions CREATEd +CREATE AGGREGATE newavg ( + sfunc1 = int4pl, basetype = int4, stype1 = int4, + sfunc2 = int4inc, stype2 = int4, + finalfunc = int4div, + initcond1 = '0', initcond2 = '0' +); + +-- sfunc1 (value-dependent) only +CREATE AGGREGATE newsum ( + sfunc1 = int4pl, basetype = int4, stype1 = int4, + initcond1 = '0' +); + +-- sfunc2 (value-independent) only +CREATE AGGREGATE newcnt ( + sfunc2 = int4inc, basetype = int4, stype2 = int4, + initcond2 = '0' +); + +VACUUM; + |