pg_amproc stores information about support procedures associated with access method operator families. There is one row for each support procedure belonging to an operator family.
| || ||Row identifier (hidden attribute; must be explicitly selected)|
| || || ||The operator family this entry is for|
| || || ||Left-hand input data type of associated operator|
| || || ||Right-hand input data type of associated operator|
| || ||Support procedure number|
| || || ||OID of the procedure|
The usual interpretation of the
amprocrighttype fields is that they identify the left and right input types of the operator(s) that a particular support procedure supports. For some access methods these match the input data type(s) of the support procedure itself, for others not. There is a notion of "default" support procedures for an index, which are those with
amprocrighttype both equal to the index operator class's
© 1996–2017 The PostgreSQL Global Development Group
Licensed under the PostgreSQL License.