diff options
Diffstat (limited to 'src/test/regress/sql/create_operator.sql')
-rw-r--r-- | src/test/regress/sql/create_operator.sql | 20 |
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 |