Movatterモバイル変換


[0]ホーム

URL:



Facebook
Postgres Pro
Facebook
Downloads
51.34. pg_operator
Prev UpChapter 51. System CatalogsHome Next

51.34. pg_operator#

The catalogpg_operator stores information about operators. SeeCREATE OPERATOR andSection 36.14 for more information.

Table 51.34. pg_operator Columns

Column Type

Description

oidoid

Row identifier

oprnamename

Name of the operator

oprnamespaceoid (referencespg_namespace.oid)

The OID of the namespace that contains this operator

oprowneroid (referencespg_authid.oid)

Owner of the operator

oprkindchar

b = infix operator (both), orl = prefix operator (left)

oprcanmergebool

This operator supports merge joins

oprcanhashbool

This operator supports hash joins

oprleftoid (referencespg_type.oid)

Type of the left operand (zero for a prefix operator)

oprrightoid (referencespg_type.oid)

Type of the right operand

oprresultoid (referencespg_type.oid)

Type of the result (zero for a not-yet-definedshell operator)

oprcomoid (referencespg_operator.oid)

Commutator of this operator (zero if none)

oprnegateoid (referencespg_operator.oid)

Negator of this operator (zero if none)

oprcoderegproc (referencespg_proc.oid)

Function that implements this operator (zero for a not-yet-definedshell operator)

oprrestregproc (referencespg_proc.oid)

Restriction selectivity estimation function for this operator (zero if none)

oprjoinregproc (referencespg_proc.oid)

Join selectivity estimation function for this operator (zero if none)



Prev Up Next
51.33. pg_opclass Home 51.35. pg_opfamily
pdfepub
Go to Postgres Pro Standard 17
By continuing to browse this website, you agree to the use of cookies. Go toPrivacy Policy.

[8]ページ先頭

©2009-2025 Movatter.jp