Movatterモバイル変換


[0]ホーム

URL:



Facebook
Postgres Pro
Facebook
Downloads
51.5. pg_amproc
Prev UpChapter 51. System CatalogsHome Next

51.5. pg_amproc#

The catalogpg_amproc stores information about support functions associated with access method operator families. There is one row for each support function belonging to an operator family.

Table 51.5. pg_amproc Columns

Column Type

Description

oidoid

Row identifier

amprocfamilyoid (referencespg_opfamily.oid)

The operator family this entry is for

amproclefttypeoid (referencespg_type.oid)

Left-hand input data type of associated operator

amprocrighttypeoid (referencespg_type.oid)

Right-hand input data type of associated operator

amprocnumint2

Support function number

amprocregproc (referencespg_proc.oid)

OID of the function


The usual interpretation of theamproclefttype andamprocrighttype fields is that they identify the left and right input types of the operator(s) that a particular support function supports. For some access methods these match the input data type(s) of the support function itself, for others not. There is a notion ofdefault support functions for an index, which are those withamproclefttype andamprocrighttype both equal to the index operator class'sopcintype.


Prev Up Next
51.4. pg_amop Home 51.6. pg_attrdef
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