This page in other versions: 9.2 / 9.3 / 9.4 / 9.5 / current (9.6)  |  Development versions: devel  |  Unsupported versions: 7.1 / 7.2 / 7.3 / 7.4 / 8.0 / 8.1 / 8.2 / 8.3 / 8.4 / 9.0 / 9.1

3.14. pg_operator

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

Table 3-14. pg_operator Columns

Name Type References Description
oprname name   Name of the operator
oprowner int4 pg_shadow.usesysid Owner (creator) of the operator
oprprec int2   unused
oprkind char   'b' = infix ("both"), 'l' = prefix ("left"), 'r' = postfix ("right")
oprisleft bool   unused
oprcanhash bool   This operator supports hash joins.
oprleft oid pg_type.oid Type of the left operand
oprright oid pg_type.oid Type of the right operand
oprresult oid pg_type.oid Type of the result
oprcom oid pg_operator.oid Commutator of this operator, if any
oprnegate oid pg_operator.oid Negator of this operator, if any
oprlsortop oid pg_operator.oid If this operator supports merge joins, the operator that sorts the type of the left-hand operand
oprrsortop oid pg_operator.oid If this operator supports merge joins, the operator that sorts the type of the right-hand operand
oprcode regproc   Function that implements this operator
oprrest regproc   Restriction selectivity estimation function for this operator
oprjoin regproc   Join selectivity estimation function for this operator

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

Privacy Policy | About PostgreSQL
Copyright © 1996-2016 The PostgreSQL Global Development Group