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. A family member can be either a search operator or an ordering operator. An operator can appear in more than one family, but cannot appear in more than one search position nor more than one ordering position within a family. (It is allowed, though unlikely, for an operator to be used for both search and ordering purposes.)
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- catalog
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- oid, amopfamily, amoplefttype, amoprighttype, amopstrategy, amoppurpose, amopopr, amopmethod, amopsortfamily
- runtime verified
- false
- source
- english-manual
Definition PG 18
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. A family member can be either a search operator or an ordering operator. An operator can appear in more than one family, but cannot appear in more than one search position nor more than one ordering position within a family. (It is allowed, though unlikely, for an operator to be used for both search and ordering purposes.)
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| oid | oid | Not null | Row identifier |
| amopfamily | oid | Not null | The operator family this entry is for |
| amoplefttype | oid | Not null | Left-hand input data type of operator |
| amoprighttype | oid | Not null | Right-hand input data type of operator |
| amopstrategy | int2 | Not null | Operator strategy number |
| amoppurpose | char | Not null | Operator purpose, either s for search or o for ordering |
| amopopr | oid | Not null | OID of the operator |
| amopmethod | oid | Not null | Index access method operator family is for |
| amopsortfamily | oid | Not null | The B-tree operator family this entry sorts according to, if an ordering operator; zero if a search operator |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:c93f23a64abda7e4d8f9e4837d752bb90ab408c464d9823afa7de40bade4ec14
Text language: en · catalog-bilingual-repair:c93f23a64abda7e4d8f9e4837d752bb90ab408c464d9823afa7de40bade4ec14