brin/box_inclusion_ops (family)
BRIN operator family containing 1 classes, 13 operator strategies and 6 support functions in this source build.
当前阅读 PG 18·选择有来源记录的版本
此版本暂无所选语言的定义，以下显示原始英文内容。
- Object kind
- Operator family
- Index AM
- BRIN
- aliases
- box_inclusion_ops, brin/box_inclusion_ops
- classes
- map[default:t family:box_inclusion_ops family_slug:family-brin-box_inclusion_ops input_type:box key_type:box method:brin name:box_inclusion_ops slug:class-brin-box_inclusion_ops source_oid:]
- signature
- brin/box_inclusion_ops
- source oid
- 4104
版本定义 PG 18
BRIN operator family containing 1 classes, 13 operator strategies and 6 support functions in this source build.
Family operator strategies
| Operator overload | Strategy | Purpose | Ordering family | Membership scope | Source description |
|---|---|---|---|---|---|
| <<(box,box) | 1 | search | Family member | is left of | |
| &<(box,box) | 2 | search | Family member | overlaps or is left of | |
| &&(box,box) | 3 | search | Family member | overlaps | |
| &>(box,box) | 4 | search | Family member | overlaps or is right of | |
| >>(box,box) | 5 | search | Family member | is right of | |
| ~=(box,box) | 6 | search | Family member | same as | |
| @>(box,box) | 7 | search | Family member | contains | |
| <@(box,box) | 8 | search | Family member | is contained by | |
| &<|(box,box) | 9 | search | Family member | overlaps or is below | |
| <<|(box,box) | 10 | search | Family member | is below | |
| |>>(box,box) | 11 | search | Family member | is above | |
| |&>(box,box) | 12 | search | Family member | overlaps or is above | |
| @>(box,point) | 7 | search | Family member | contains |
Family support functions
| Support number | Left type | Right type | Function signature | Result type |
|---|---|---|---|---|
| 1 | box | box | brin_inclusion_opcinfo(internal) | internal |
| 2 | box | box | brin_inclusion_add_value(internal,internal,internal,internal) | bool |
| 3 | box | box | brin_inclusion_consistent(internal,internal,internal) | bool |
| 4 | box | box | brin_inclusion_union(internal,internal,internal) | bool |
| 11 | box | box | bound_box(box,box) | box |
| 13 | box | box | box_contain(box,box) | bool |
Classes in this family
| Class | Input type | Key type | Default |
|---|---|---|---|
| box_inclusion_ops | box | box | yes |
比较版本
完整来源事实
family
{"method":"brin","name":"box_inclusion_ops"}operators
map[description:is left of family:box_inclusion_ops family_slug:family-brin-box_inclusion_ops left_type:box method:brin operator:<<(box,box) operator_slug:op-3c3c-box-box purpose:search result_type:bool right_type:box sort_family: sort_family_slug: strategy:1], map[description:overlaps or is left of family:box_inclusion_ops family_slug:family-brin-box_inclusion_ops left_type:box method:brin operator:&<(box,box) operator_slug:op-263c-box-box purpose:search result_type:bool right_type:box sort_family: sort_family_slug: strategy:2], map[description:overlaps family:box_inclusion_ops family_slug:family-brin-box_inclusion_ops left_type:box method:brin operator:&&(box,box) operator_slug:op-2626-box-box purpose:search result_type:bool right_type:box sort_family: sort_family_slug: strategy:3], map[description:overlaps or is right of family:box_inclusion_ops family_slug:family-brin-box_inclusion_ops left_type:box method:brin operator:&>(box,box) operator_slug:op-263e-box-box purpose:search result_type:bool right_type:box sort_family: sort_family_slug: strategy:4], map[description:is right of family:box_inclusion_ops family_slug:family-brin-box_inclusion_ops left_type:box method:brin operator:>>(box,box) operator_slug:op-3e3e-box-box purpose:search result_type:bool right_type:box sort_family: sort_family_slug: strategy:5], map[description:same as family:box_inclusion_ops family_slug:family-brin-box_inclusion_ops left_type:box method:brin operator:~=(box,box) operator_slug:op-7e3d-box-box purpose:search result_type:bool right_type:box sort_family: sort_family_slug: strategy:6], map[description:contains family:box_inclusion_ops family_slug:family-brin-box_inclusion_ops left_type:box method:brin operator:@>(box,box) operator_slug:op-403e-box-box purpose:search result_type:bool right_type:box sort_family: sort_family_slug: strategy:7], map[description:is contained by family:box_inclusion_ops family_slug:family-brin-box_inclusion_ops left_type:box method:brin operator:<@(box,box) operator_slug:op-3c40-box-box purpose:search result_type:bool right_type:box sort_family: sort_family_slug: strategy:8], map[description:overlaps or is below family:box_inclusion_ops family_slug:family-brin-box_inclusion_ops left_type:box method:brin operator:&<|(box,box) operator_slug:op-263c7c-box-box purpose:search result_type:bool right_type:box sort_family: sort_family_slug: strategy:9], map[description:is below family:box_inclusion_ops family_slug:family-brin-box_inclusion_ops left_type:box method:brin operator:<<|(box,box) operator_slug:op-3c3c7c-box-box purpose:search result_type:bool right_type:box sort_family: sort_family_slug: strategy:10], map[description:is above family:box_inclusion_ops family_slug:family-brin-box_inclusion_ops left_type:box method:brin operator:|>>(box,box) operator_slug:op-7c3e3e-box-box purpose:search result_type:bool right_type:box sort_family: sort_family_slug: strategy:11], map[description:overlaps or is above family:box_inclusion_ops family_slug:family-brin-box_inclusion_ops left_type:box method:brin operator:|&>(box,box) operator_slug:op-7c263e-box-box purpose:search result_type:bool right_type:box sort_family: sort_family_slug: strategy:12], map[description:contains family:box_inclusion_ops family_slug:family-brin-box_inclusion_ops left_type:box method:brin operator:@>(box,point) operator_slug:op-403e-box-point purpose:search result_type:bool right_type:point sort_family: sort_family_slug: strategy:7]
support functions
map[family:box_inclusion_ops family_slug:family-brin-box_inclusion_ops function:brin_inclusion_opcinfo(internal) left_type:box method:brin number:1 result_type:internal right_type:box], map[family:box_inclusion_ops family_slug:family-brin-box_inclusion_ops function:brin_inclusion_add_value(internal,internal,internal,internal) left_type:box method:brin number:2 result_type:bool right_type:box], map[family:box_inclusion_ops family_slug:family-brin-box_inclusion_ops function:brin_inclusion_consistent(internal,internal,internal) left_type:box method:brin number:3 result_type:bool right_type:box], map[family:box_inclusion_ops family_slug:family-brin-box_inclusion_ops function:brin_inclusion_union(internal,internal,internal) left_type:box method:brin number:4 result_type:bool right_type:box], map[family:box_inclusion_ops family_slug:family-brin-box_inclusion_ops function:bound_box(box,box) left_type:box method:brin number:11 result_type:box right_type:box], map[family:box_inclusion_ops family_slug:family-brin-box_inclusion_ops function:box_contain(box,box) left_type:box method:brin number:13 result_type:bool right_type:box]
来源引用
- Matching PostgreSQL source archive
- PostgreSQL 18 English manual: indexes-opclass.html
- PostgreSQL 18 English manual: catalog-pg-opfamily.html
- PostgreSQL 18 English manual: catalog-pg-amop.html
- PostgreSQL 18 English manual: catalog-pg-amproc.html
- 固定 PostgreSQL 源码归档
定义来源
center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f
正文语言: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f