2
$PostgreSQL: pgsql/doc/src/sgml/ref/alter_operator.sgml,v 1.1 2004-06-25 21:55:50 tgl Exp $
3
PostgreSQL documentation
6
<refentry id="SQL-ALTEROPERATOR">
8
<refentrytitle id="SQL-ALTEROPERATOR-TITLE">ALTER OPERATOR</refentrytitle>
9
<refmiscinfo>SQL - Language Statements</refmiscinfo>
13
<refname>ALTER OPERATOR</refname>
14
<refpurpose>change the definition of an operator</refpurpose>
17
<indexterm zone="sql-alteroperator">
18
<primary>ALTER OPERATOR</primary>
23
ALTER OPERATOR <replaceable>name</replaceable> ( { <replaceable>lefttype</replaceable> | NONE } , { <replaceable>righttype</replaceable> | NONE } ) OWNER TO <replaceable>newowner</replaceable>
28
<title>Description</title>
31
<command>ALTER OPERATOR</command> changes the definition of
32
an operator. The only currently available functionality is to change the
33
owner of the operator.
38
<title>Parameters</title>
42
<term><replaceable class="parameter">name</replaceable></term>
45
The name (optionally schema-qualified) of an existing operator.
51
<term><replaceable class="parameter">lefttype</replaceable></term>
54
The data type of the operator's left operand; write
55
<literal>NONE</literal> if the operator has no left operand.
61
<term><replaceable class="parameter">righttype</replaceable></term>
64
The data type of the operator's right operand; write
65
<literal>NONE</literal> if the operator has no right operand.
71
<term><replaceable class="parameter">newowner</replaceable></term>
74
The new owner of the operator.
75
You must be a superuser to change the owner of an operator.
83
<title>Examples</title>
86
Change the owner of a custom operator <literal>a @@ b</literal> for type <type>text</type>:
88
ALTER OPERATOR @@ (text, text) OWNER TO joe;
94
<title>Compatibility</title>
97
There is no <command>ALTER OPERATOR</command> statement in
103
<title>See Also</title>
105
<simplelist type="inline">
106
<member><xref linkend="sql-createoperator" endterm="sql-createoperator-title"></member>
107
<member><xref linkend="sql-dropoperator" endterm="sql-dropoperator-title"></member>
112
<!-- Keep this comment at the end of the file
117
sgml-minimize-attributes:nil
118
sgml-always-quote-attributes:t
121
sgml-parent-document:nil
122
sgml-default-dtd-file:"../reference.ced"
123
sgml-exposed-tags:nil
124
sgml-local-catalogs:"/usr/lib/sgml/catalog"
125
sgml-local-ecat-files:nil