HomeMogDBMogDB StackUqbar
v1.1

Documentation:v1.1

Supported Versions:

PG_OPERATOR

PG_OPERATOR records information about operators.

Table 1 PG_OPERATOR columns

Name Type Reference Description
oid oid - Row identifier (hidden attribute, which must be specified)
oprname name - Name of an operator
oprnamespace oid PG_NAMESPACE.oid OID of the namespace that contains the operator
oprowner oid PG_AUTHID.oid Owner of the operator
oprkind "char" - - b: infix ("both")
- l: prefix ("left")
- r: postfix ("right")
oprcanmerge Boolean - Whether the operator supports merge joins
oprcanhash Boolean - Whether the 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
oprcode regproc PG_PROC.proname Function that implements the operator
oprrest regproc PG_PROC.proname Restriction selectivity estimation function for the operator
oprjoin regproc PG_PROC.proname Join selectivity estimation function for the operator
Copyright © 2011-2024 www.enmotech.com All rights reserved.