3.23. pg_operator

See CREATE OPERATOR and the Programmer's Guide for details on these operator parameters.

Table 3-23. pg_operator Columns

NameTypeReferencesDescription
oprnamename Name of the operator
oprnamespaceoidpg_namespace.oid The OID of the namespace that contains this operator
oprownerint4pg_shadow.usesysidOwner (creator) of the operator
oprkindchar  'b' = infix ("both"), 'l' = prefix ("left"), 'r' = postfix ("right")
oprcanhashbool This operator supports hash joins.
oprleftoidpg_type.oidType of the left operand
oprrightoidpg_type.oidType of the right operand
oprresultoidpg_type.oidType of the result
oprcomoidpg_operator.oidCommutator of this operator, if any
oprnegateoidpg_operator.oidNegator of this operator, if any
oprlsortopoidpg_operator.oid If this operator supports merge joins, the operator that sorts the type of the left-hand operand (L<L)
oprrsortopoidpg_operator.oid If this operator supports merge joins, the operator that sorts the type of the right-hand operand (R<R)
oprltcmpopoidpg_operator.oid If this operator supports merge joins, the less-than operator that compares the left and right operand types (L<R)
oprgtcmpopoidpg_operator.oid If this operator supports merge joins, the greater-than operator that compares the left and right operand types (L>R)
oprcoderegprocpg_proc.oidFunction that implements this operator
oprrestregprocpg_proc.oidRestriction selectivity estimation function for this operator
oprjoinregprocpg_proc.oidJoin selectivity estimation function for this operator

Unused fields contain zeroes, for example oprleft is zero for a prefix operator.