|
oprname
|
name
|
|
Name of the operator |
|
oprnamespace
|
oid
|
pg_namespace
.oid
|
The OID of the namespace that contains this operator |
|
oprowner
|
oid
|
pg_authid
.oid
|
Owner of the operator |
|
oprkind
|
char
|
|
b = infix ("both"), l = prefix ("left"), r = postfix ("right") |
|
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 (L<L) |
|
oprrsortop
|
oid
|
pg_operator
.oid
|
If this operator supports merge joins, the operator that sorts the type of the right-hand operand (R<R) |
|
oprltcmpop
|
oid
|
pg_operator
.oid
|
If this operator supports merge joins, the less-than operator that compares the left and right operand types (L<R) |
|
oprgtcmpop
|
oid
|
pg_operator
.oid
|
If this operator supports merge joins, the greater-than operator that compares the left and right operand types (L>R) |
|
oprcode
|
regproc
|
pg_proc
.oid
|
Function that implements this operator |
|
oprrest
|
regproc
|
pg_proc
.oid
|
Restriction selectivity estimation function for this operator |
|
oprjoin
|
regproc
|
pg_proc
.oid
|
Join selectivity estimation function for this operator |
