aboutsummaryrefslogtreecommitdiff
path: root/src/test/regress/sql/create_operator.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/regress/sql/create_operator.sql')
-rw-r--r--src/test/regress/sql/create_operator.sql20
1 files changed, 10 insertions, 10 deletions
diff --git a/src/test/regress/sql/create_operator.sql b/src/test/regress/sql/create_operator.sql
index 8b6fd0bb43d..c32da8c066a 100644
--- a/src/test/regress/sql/create_operator.sql
+++ b/src/test/regress/sql/create_operator.sql
@@ -19,17 +19,17 @@ CREATE OPERATOR <% (
CREATE OPERATOR @#@ (
rightarg = int8, -- left unary
- procedure = numeric_fac
+ procedure = factorial
);
CREATE OPERATOR #@# (
leftarg = int8, -- right unary
- procedure = numeric_fac
+ procedure = factorial
);
CREATE OPERATOR #%# (
leftarg = int8, -- right unary
- procedure = numeric_fac
+ procedure = factorial
);
-- Test operator created above
@@ -42,7 +42,7 @@ COMMENT ON OPERATOR ###### (int4, NONE) IS 'bad right unary';
-- => is disallowed now
CREATE OPERATOR => (
leftarg = int8, -- right unary
- procedure = numeric_fac
+ procedure = factorial
);
-- lexing of <=, >=, <>, != has a number of edge cases
@@ -51,7 +51,7 @@ CREATE OPERATOR => (
-- this is legal because ! is not allowed in sql ops
CREATE OPERATOR !=- (
leftarg = int8, -- right unary
- procedure = numeric_fac
+ procedure = factorial
);
SELECT 2 !=-;
-- make sure lexer returns != as <> even in edge cases
@@ -85,7 +85,7 @@ REVOKE USAGE ON SCHEMA schema_op1 FROM regress_rol_op1;
SET ROLE regress_rol_op1;
CREATE OPERATOR schema_op1.#*# (
leftarg = int8, -- right unary
- procedure = numeric_fac
+ procedure = factorial
);
ROLLBACK;
@@ -94,7 +94,7 @@ ROLLBACK;
BEGIN TRANSACTION;
CREATE OPERATOR #*# (
leftarg = SETOF int8,
- procedure = numeric_fac
+ procedure = factorial
);
ROLLBACK;
@@ -103,7 +103,7 @@ ROLLBACK;
BEGIN TRANSACTION;
CREATE OPERATOR #*# (
rightarg = SETOF int8,
- procedure = numeric_fac
+ procedure = factorial
);
ROLLBACK;
@@ -129,13 +129,13 @@ ROLLBACK;
-- Should fail. Invalid attribute
CREATE OPERATOR #@%# (
leftarg = int8, -- right unary
- procedure = numeric_fac,
+ procedure = factorial,
invalid_att = int8
);
-- Should fail. At least leftarg or rightarg should be mandatorily specified
CREATE OPERATOR #@%# (
- procedure = numeric_fac
+ procedure = factorial
);
-- Should fail. Procedure should be mandatorily specified