summaryrefslogtreecommitdiff
path: root/src/test
diff options
context:
space:
mode:
Diffstat (limited to 'src/test')
-rw-r--r--src/test/regress/expected/create_operator.out14
-rw-r--r--src/test/regress/sql/create_operator.sql14
2 files changed, 12 insertions, 16 deletions
diff --git a/src/test/regress/expected/create_operator.out b/src/test/regress/expected/create_operator.out
index 7685dbe802..df25f35ae7 100644
--- a/src/test/regress/expected/create_operator.out
+++ b/src/test/regress/expected/create_operator.out
@@ -15,19 +15,17 @@ CREATE OPERATOR <% (
negator = >=%
);
CREATE OPERATOR @#@ (
- rightarg = int4, -- left unary
- procedure = int4fac
+ rightarg = int8, -- left unary
+ procedure = numeric_fac
);
CREATE OPERATOR #@# (
- leftarg = int4, -- right unary
- procedure = int4fac
+ leftarg = int8, -- right unary
+ procedure = numeric_fac
);
CREATE OPERATOR #%# (
- leftarg = int4, -- right unary
- procedure = int4fac
+ leftarg = int8, -- right unary
+ procedure = numeric_fac
);
-- Test comments
COMMENT ON OPERATOR ###### (int4, NONE) IS 'bad right unary';
ERROR: operator does not exist: integer ######
-COMMENT ON OPERATOR #%# (int4, NONE) IS 'right unary';
-COMMENT ON OPERATOR #%# (int4, NONE) IS NULL;
diff --git a/src/test/regress/sql/create_operator.sql b/src/test/regress/sql/create_operator.sql
index 4167bf3ab8..6637629ea4 100644
--- a/src/test/regress/sql/create_operator.sql
+++ b/src/test/regress/sql/create_operator.sql
@@ -18,23 +18,21 @@ CREATE OPERATOR <% (
);
CREATE OPERATOR @#@ (
- rightarg = int4, -- left unary
- procedure = int4fac
+ rightarg = int8, -- left unary
+ procedure = numeric_fac
);
CREATE OPERATOR #@# (
- leftarg = int4, -- right unary
- procedure = int4fac
+ leftarg = int8, -- right unary
+ procedure = numeric_fac
);
CREATE OPERATOR #%# (
- leftarg = int4, -- right unary
- procedure = int4fac
+ leftarg = int8, -- right unary
+ procedure = numeric_fac
);
-- Test comments
COMMENT ON OPERATOR ###### (int4, NONE) IS 'bad right unary';
-COMMENT ON OPERATOR #%# (int4, NONE) IS 'right unary';
-COMMENT ON OPERATOR #%# (int4, NONE) IS NULL;