summaryrefslogtreecommitdiff
path: root/src/test
diff options
context:
space:
mode:
authorPeter Eisentraut2020-06-18 06:41:31 +0000
committerPeter Eisentraut2020-06-18 06:41:31 +0000
commit0a40563eadc67472d6fd50dabf7002afa25c3330 (patch)
treeebc2b5a11f9a49201f8a11230b96e986d6d46b15 /src/test
parent9d402c73ade412bdeb9064c81fc4ed071c4e93f8 (diff)
Disallow factorial of negative numbers
The previous implementation returned 1 for all negative numbers, which is not sensible under any definition. Discussion: https://www.postgresql.org/message-id/flat/6ce1df0e-86a3-e544-743a-f357ff663f68%402ndquadrant.com
Diffstat (limited to 'src/test')
-rw-r--r--src/test/regress/expected/numeric.out12
1 files changed, 2 insertions, 10 deletions
diff --git a/src/test/regress/expected/numeric.out b/src/test/regress/expected/numeric.out
index b255be7c852..2f3ecb50a73 100644
--- a/src/test/regress/expected/numeric.out
+++ b/src/test/regress/expected/numeric.out
@@ -2345,14 +2345,6 @@ SELECT 0!;
(1 row)
SELECT -4!;
- ?column?
-----------
- 1
-(1 row)
-
+ERROR: factorial of a negative number is undefined
SELECT factorial(-4);
- factorial
------------
- 1
-(1 row)
-
+ERROR: factorial of a negative number is undefined