Provided by: postgresql-client-8.0_8.0.7-2build1_i386 bug

NAME
       ALTER OPERATOR - change the definition of an operator


SYNOPSIS
       ALTER OPERATOR name ( { lefttype | NONE } , { righttype | NONE } ) OWNER TO newowner


DESCRIPTION
       ALTER  OPERATOR  changes  the  definition  of  an  operator.  The  only
       currently available  functionality  is  to  change  the  owner  of  the
       operator.


PARAMETERS
       name   The  name (optionally schema-qualified) of an existing operator.

       lefttype
              The data type of the operator’s left operand; write NONE if  the
              operator has no left operand.

       righttype
              The data type of the operator’s right operand; write NONE if the
              operator has no right operand.

       newowner
              The new owner of the operator.   You  must  be  a  superuser  to
              change the owner of an operator.


EXAMPLES
       Change the owner of a custom operator a @@ b for type text:

       ALTER OPERATOR @@ (text, text) OWNER TO joe;


COMPATIBILITY
       There is no ALTER OPERATOR statement in the SQL standard.


SEE ALSO
       CREATE OPERATOR [create_operator(7)], DROP OPERATOR [drop_operator(l)]