PostgreSQL 8.3.1 Documentation
Prev | Fast Backward | Chapter 44. System Catalogs | Fast Forward | Next

# 44.4. `pg_amop`

The catalog `pg_amop` stores information about operators associated with access method operator families. There is one row for each operator that is a member of an operator family. An operator can appear in more than one family, but cannot appear in more than one position within a family.

Table 44-4. `pg_amop` Columns

Name | Type | References | Description
--- | --- | --- | ---
`amopfamily` | `oid` | ``pg_opfamily`.oid` | The operator family this entry is for
`amoplefttype` | `oid` | ``pg_type`.oid` | Left-hand input data type of operator
`amoprighttype` | `oid` | ``pg_type`.oid` | Right-hand input data type of operator
`amopstrategy` | `int2` |  | Operator strategy number
`amopreqcheck` | `bool` |  | Index hit must be rechecked
`amopopr` | `oid` | ``pg_operator`.oid` | OID of the operator
`amopmethod` | `oid` | ``pg_am`.oid` | Index access method operator family is for

An entry's `amopmethod` must match the `opfmethod` of its containing operator family (including `amopmethod` here is an intentional denormalization of the catalog structure for performance reasons). Also, `amoplefttype` and `amoprighttype` must match the `oprleft` and `oprright` fields of the referenced `pg_operator` entry.

Prev | Home | Next
`pg_am` | Up | `pg_amproc`