diff options
| author | Peter Eisentraut <peter@eisentraut.org> | 2020-06-18 08:41:31 +0200 |
|---|---|---|
| committer | Peter Eisentraut <peter@eisentraut.org> | 2020-06-18 08:41:31 +0200 |
| commit | 9d402c73ade412bdeb9064c81fc4ed071c4e93f8 (patch) | |
| tree | 3d93e63346682afa1bf742de663a5770ce5713f6 /src/test/regress/sql/numeric.sql | |
| parent | 2b2a070d98b2f2c7ecc031e582cfefa400316ce3 (diff) | |
| download | postgresql-9d402c73ade412bdeb9064c81fc4ed071c4e93f8.tar.gz | |
Expand tests for factorial
Move from int4 to numeric test. (They were originally int4 functions,
but were reimplemented for numeric in
04a4821adef38155b7920ba9eb83c4c3c29156f8.) Add some tests for edge
cases.
Discussion: https://www.postgresql.org/message-id/flat/6ce1df0e-86a3-e544-743a-f357ff663f68%402ndquadrant.com
Diffstat (limited to 'src/test/regress/sql/numeric.sql')
| -rw-r--r-- | src/test/regress/sql/numeric.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/src/test/regress/sql/numeric.sql b/src/test/regress/sql/numeric.sql index 41475a9a24..1332a9cf07 100644 --- a/src/test/regress/sql/numeric.sql +++ b/src/test/regress/sql/numeric.sql @@ -1111,3 +1111,14 @@ FROM (VALUES (0::numeric, 0::numeric), (4232.820::numeric, 132.72000::numeric)) AS v(a, b); SELECT lcm(9999 * (10::numeric)^131068 + (10::numeric^131068 - 1), 2); -- overflow + +-- +-- Tests for factorial +-- +SELECT 4!; +SELECT !!3; +SELECT factorial(15); +SELECT 100000!; +SELECT 0!; +SELECT -4!; +SELECT factorial(-4); |