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

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
Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group