Home • Explore • Blog • CI
☰



postgresql
2nd chunk of `doc/src/sgml/ref/alter_operator.sgml`
1abec3803c07f7e9a90413db7ddc4cc7b8ff12b7904c6d0000000001000008a9
 <varlistentry>
    <term><replaceable class="parameter">left_type</replaceable></term>
    <listitem>
     <para>
      The data type of the operator's left operand; write
      <literal>NONE</literal> if the operator has no left operand.
     </para>
    </listitem>
   </varlistentry>

   <varlistentry>
    <term><replaceable class="parameter">right_type</replaceable></term>
    <listitem>
     <para>
      The data type of the operator's right operand.
     </para>
    </listitem>
   </varlistentry>

   <varlistentry>
    <term><replaceable class="parameter">new_owner</replaceable></term>
    <listitem>
     <para>
      The new owner of the operator.
     </para>
    </listitem>
   </varlistentry>

   <varlistentry>
    <term><replaceable class="parameter">new_schema</replaceable></term>
    <listitem>
     <para>
      The new schema for the operator.
     </para>
    </listitem>
   </varlistentry>

   <varlistentry>
     <term><replaceable class="parameter">res_proc</replaceable></term>
     <listitem>
       <para>
         The restriction selectivity estimator function for this operator; write NONE to remove existing selectivity estimator.
       </para>
      </listitem>
   </varlistentry>

   <varlistentry>
     <term><replaceable class="parameter">join_proc</replaceable></term>
     <listitem>
       <para>
         The join selectivity estimator function for this operator; write NONE to remove existing selectivity estimator.
       </para>
     </listitem>
   </varlistentry>

   <varlistentry>
    <term><replaceable class="parameter">com_op</replaceable></term>
    <listitem>
     <para>
      The commutator of this operator. Can only be changed if the operator
      does not have an existing commutator.
     </para>
    </listitem>
   </varlistentry>

   <varlistentry>
    <term><replaceable class="parameter">neg_op</replaceable></term>
    <listitem>
     <para>
      The negator of this operator. Can only be changed if the operator does
      not have an existing negator.
     </para>
    </listitem>
   </varlistentry>

   <varlistentry>
    <term><literal>HASHES</literal></term>
    <listitem>
     <para>
      Indicates this operator can support a hash join. Can
Title: ALTER OPERATOR Parameters
Summary
This section describes the parameters available for the ALTER OPERATOR command. These include the left and right operand data types, the new owner and schema, and selectivity estimator functions (res_proc and join_proc). It also covers the commutator (com_op) and negator (neg_op) operators, and the HASHES option to indicate hash join support.