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.sql32
1 files changed, 32 insertions, 0 deletions
diff --git a/src/test/regress/sql/create_operator.sql b/src/test/regress/sql/create_operator.sql
new file mode 100644
index 00000000000..60e44207820
--- /dev/null
+++ b/src/test/regress/sql/create_operator.sql
@@ -0,0 +1,32 @@
+--
+-- OPERATOR DEFINITIONS
+--
+CREATE OPERATOR ## (
+ leftarg = path,
+ rightarg = path,
+ procedure = path_inter,
+ commutator = ##
+);
+
+CREATE OPERATOR <% (
+ leftarg = point,
+ rightarg = circle,
+ procedure = pt_in_circle,
+ commutator = >=%
+);
+
+CREATE OPERATOR @#@ (
+ rightarg = int4, -- left unary
+ procedure = int4fac
+);
+
+CREATE OPERATOR #@# (
+ leftarg = int4, -- right unary
+ procedure = int4fac
+);
+
+CREATE OPERATOR #%# (
+ leftarg = int4, -- right unary
+ procedure = int4fac
+);
+