diff options
| author | Peter Eisentraut <peter@eisentraut.org> | 2020-09-09 09:58:12 +0200 |
|---|---|---|
| committer | Peter Eisentraut <peter@eisentraut.org> | 2020-09-09 09:58:12 +0200 |
| commit | fe2bf8f81096ea1b7b2fc58501309fc5e41ccd47 (patch) | |
| tree | f0e50a5456999f27d98fd77aae8f2020b99436b6 /src/test/regress/sql/numeric.sql | |
| parent | f481d2823297e692e9d44c9edfd18e626e768b0c (diff) | |
| download | postgresql-fe2bf8f81096ea1b7b2fc58501309fc5e41ccd47.tar.gz | |
Add some more numeric test coverage
max(numeric) wasn't tested at all, min(numeric) was only used by some
unrelated tests. Add explicit tests with the other numeric aggregate
functions.
Diffstat (limited to 'src/test/regress/sql/numeric.sql')
| -rw-r--r-- | src/test/regress/sql/numeric.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/src/test/regress/sql/numeric.sql b/src/test/regress/sql/numeric.sql index 416c16722a..febb096af2 100644 --- a/src/test/regress/sql/numeric.sql +++ b/src/test/regress/sql/numeric.sql @@ -752,6 +752,8 @@ SELECT power('-inf'::numeric, '-inf'); -- ****************************** -- numeric AVG used to fail on some platforms SELECT AVG(val) FROM num_data; +SELECT MAX(val) FROM num_data; +SELECT MIN(val) FROM num_data; SELECT STDDEV(val) FROM num_data; SELECT VARIANCE(val) FROM num_data; |