Content-Length: 92679 | pFad | http://postgrespro.com/docs/postgrespro/13/catalog-pg-operator

Postgres Pro Standard : Documentation: 13: 50.34. pg_operator : Postgres Professional

50.34. pg_operator

The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information.

Table 50.34. pg_operator Columns

Column Type

Description

oid oid

Row identifier

oprname name

Name of the operator

oprnamespace oid (references pg_namespace.oid)

The OID of the namespace that contains this operator

oprowner oid (references pg_authid.oid)

Owner of the operator

oprkind char

b = infix (both), l = prefix (left), r = postfix (right)

oprcanmerge bool

This operator supports merge joins

oprcanhash bool

This operator supports hash joins

oprleft oid (references pg_type.oid)

Type of the left operand

oprright oid (references pg_type.oid)

Type of the right operand

oprresult oid (references pg_type.oid)

Type of the result

oprcom oid (references pg_operator.oid)

Commutator of this operator, if any

oprnegate oid (references pg_operator.oid)

Negator of this operator, if any

oprcode regproc (references pg_proc.oid)

Function that implements this operator

oprrest regproc (references pg_proc.oid)

Restriction selectivity estimation function for this operator

oprjoin regproc (references pg_proc.oid)

Join selectivity estimation function for this operator


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









ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://postgrespro.com/docs/postgrespro/13/catalog-pg-operator

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy