From a5e6e9935714959db56607b327ce0f4ff68751c1 Mon Sep 17 00:00:00 2001
From: Tom Lane
Date: Sat, 10 Aug 2002 19:01:53 +0000
Subject: Allow schema-qualified operator names to be used in the optional
arguments of CREATE OPERATOR.
---
doc/src/sgml/ref/create_operator.sgml | 11 ++++++++++-
doc/src/sgml/syntax.sgml | 15 +++++++++++++--
2 files changed, 23 insertions(+), 3 deletions(-)
(limited to 'doc/src')
diff --git a/doc/src/sgml/ref/create_operator.sgml b/doc/src/sgml/ref/create_operator.sgml
index 82ea44921d9..2a4955113f3 100644
--- a/doc/src/sgml/ref/create_operator.sgml
+++ b/doc/src/sgml/ref/create_operator.sgml
@@ -1,5 +1,5 @@
@@ -437,6 +437,15 @@ MYBOXES.description === box '((0,0), (1,1))'
Refer to DROP OPERATOR to delete
user-defined operators from a database.
+
+
+ To give a schema-qualified operator name in com_op or the other optional
+ arguments, use the OPERATOR()> syntax, for example
+
+ COMMUTATOR = OPERATOR(myschema.===) ,
+
+
diff --git a/doc/src/sgml/syntax.sgml b/doc/src/sgml/syntax.sgml
index 90f33bfd0ff..fbbe78db9a8 100644
--- a/doc/src/sgml/syntax.sgml
+++ b/doc/src/sgml/syntax.sgml
@@ -1,5 +1,5 @@
@@ -755,7 +755,7 @@ SELECT (5 !) - 6;
- LIKE ILIKE
+ LIKE ILIKE SIMILAR
string pattern matching
@@ -801,6 +801,17 @@ SELECT (5 !) - 6;
the same precedence as the built-in +
operator, no
matter what yours does.
+
+
+ When a schema-qualified operator name is used in the
+ OPERATOR> syntax, as for example in
+
+SELECT 3 OPERATOR(pg_catalog.+) 4;
+
+ the OPERATOR> construct is taken to have the default precedence
+ shown above for any other> operator. This is true no matter
+ which specific operator name appears inside OPERATOR()>.
+
--
cgit v1.2.3