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