brin/range_inclusion_ops (class)
BRIN operator class for anyrange; member of range_inclusion_ops.
当前阅读 PG 18·选择有来源记录的版本
此版本暂无所选语言的定义，以下显示原始英文内容。
- Object kind
- Operator class
- Index AM
- BRIN
- Input type
- anyrange
- Stored key type
- anyrange
- Default class
- yes
- aliases
- range_inclusion_ops, brin/range_inclusion_ops
- classes
- map[default:t family:range_inclusion_ops family_slug:family-brin-range_inclusion_ops input_type:anyrange key_type:anyrange method:brin name:range_inclusion_ops slug:class-brin-range_inclusion_ops source_oid:]
- signature
- brin/range_inclusion_ops
- source oid
- 未知
版本定义 PG 18
BRIN operator class for anyrange; member of range_inclusion_ops.
Family operator strategies
| Operator overload | Strategy | Purpose | Ordering family | Membership scope | Source description |
|---|---|---|---|---|---|
| <<(anyrange,anyrange) | 1 | search | Class input pair | is left of | |
| &<(anyrange,anyrange) | 2 | search | Class input pair | overlaps or is left of | |
| &&(anyrange,anyrange) | 3 | search | Class input pair | overlaps | |
| &>(anyrange,anyrange) | 4 | search | Class input pair | overlaps or is right of | |
| >>(anyrange,anyrange) | 5 | search | Class input pair | is right of | |
| @>(anyrange,anyrange) | 7 | search | Class input pair | contains | |
| <@(anyrange,anyrange) | 8 | search | Class input pair | is contained by | |
| @>(anyrange,anyelement) | 16 | search | Family member | contains | |
| -|-(anyrange,anyrange) | 17 | search | Class input pair | is adjacent to | |
| =(anyrange,anyrange) | 18 | search | Class input pair | equal | |
| <(anyrange,anyrange) | 20 | search | Class input pair | less than | |
| <=(anyrange,anyrange) | 21 | search | Class input pair | less than or equal | |
| >(anyrange,anyrange) | 22 | search | Class input pair | greater than | |
| >=(anyrange,anyrange) | 23 | search | Class input pair | greater than or equal |
Family support functions
| Support number | Left type | Right type | Function signature | Result type |
|---|---|---|---|---|
| 1 | anyrange | anyrange | brin_inclusion_opcinfo(internal) | internal |
| 2 | anyrange | anyrange | brin_inclusion_add_value(internal,internal,internal,internal) | bool |
| 3 | anyrange | anyrange | brin_inclusion_consistent(internal,internal,internal) | bool |
| 4 | anyrange | anyrange | brin_inclusion_union(internal,internal,internal) | bool |
| 11 | anyrange | anyrange | range_merge(anyrange,anyrange) | anyrange |
| 13 | anyrange | anyrange | range_contains(anyrange,anyrange) | bool |
| 14 | anyrange | anyrange | isempty(anyrange) | bool |
Classes in this family
| Class | Input type | Key type | Default |
|---|---|---|---|
| range_inclusion_ops | anyrange | anyrange | yes |
比较版本
完整来源事实
class
{"default":"t","family":"range_inclusion_ops","input_type":"anyrange","key_type":"anyrange","method":"brin","name":"range_inclusion_ops"}operators
map[description:is left of family:range_inclusion_ops family_slug:family-brin-range_inclusion_ops left_type:anyrange method:brin operator:<<(anyrange,anyrange) operator_slug:op-3c3c-anyrange-anyrange purpose:search result_type:bool right_type:anyrange sort_family: sort_family_slug: strategy:1], map[description:overlaps or is left of family:range_inclusion_ops family_slug:family-brin-range_inclusion_ops left_type:anyrange method:brin operator:&<(anyrange,anyrange) operator_slug:op-263c-anyrange-anyrange purpose:search result_type:bool right_type:anyrange sort_family: sort_family_slug: strategy:2], map[description:overlaps family:range_inclusion_ops family_slug:family-brin-range_inclusion_ops left_type:anyrange method:brin operator:&&(anyrange,anyrange) operator_slug:op-2626-anyrange-anyrange purpose:search result_type:bool right_type:anyrange sort_family: sort_family_slug: strategy:3], map[description:overlaps or is right of family:range_inclusion_ops family_slug:family-brin-range_inclusion_ops left_type:anyrange method:brin operator:&>(anyrange,anyrange) operator_slug:op-263e-anyrange-anyrange purpose:search result_type:bool right_type:anyrange sort_family: sort_family_slug: strategy:4], map[description:is right of family:range_inclusion_ops family_slug:family-brin-range_inclusion_ops left_type:anyrange method:brin operator:>>(anyrange,anyrange) operator_slug:op-3e3e-anyrange-anyrange purpose:search result_type:bool right_type:anyrange sort_family: sort_family_slug: strategy:5], map[description:contains family:range_inclusion_ops family_slug:family-brin-range_inclusion_ops left_type:anyrange method:brin operator:@>(anyrange,anyrange) operator_slug:op-403e-anyrange-anyrange purpose:search result_type:bool right_type:anyrange sort_family: sort_family_slug: strategy:7], map[description:is contained by family:range_inclusion_ops family_slug:family-brin-range_inclusion_ops left_type:anyrange method:brin operator:<@(anyrange,anyrange) operator_slug:op-3c40-anyrange-anyrange purpose:search result_type:bool right_type:anyrange sort_family: sort_family_slug: strategy:8], map[description:contains family:range_inclusion_ops family_slug:family-brin-range_inclusion_ops left_type:anyrange method:brin operator:@>(anyrange,anyelement) operator_slug:op-403e-anyrange-anyelement purpose:search result_type:bool right_type:anyelement sort_family: sort_family_slug: strategy:16], map[description:is adjacent to family:range_inclusion_ops family_slug:family-brin-range_inclusion_ops left_type:anyrange method:brin operator:-|-(anyrange,anyrange) operator_slug:op-2d7c2d-anyrange-anyrange purpose:search result_type:bool right_type:anyrange sort_family: sort_family_slug: strategy:17], map[description:equal family:range_inclusion_ops family_slug:family-brin-range_inclusion_ops left_type:anyrange method:brin operator:=(anyrange,anyrange) operator_slug:op-3d-anyrange-anyrange purpose:search result_type:bool right_type:anyrange sort_family: sort_family_slug: strategy:18], map[description:less than family:range_inclusion_ops family_slug:family-brin-range_inclusion_ops left_type:anyrange method:brin operator:<(anyrange,anyrange) operator_slug:op-3c-anyrange-anyrange purpose:search result_type:bool right_type:anyrange sort_family: sort_family_slug: strategy:20], map[description:less than or equal family:range_inclusion_ops family_slug:family-brin-range_inclusion_ops left_type:anyrange method:brin operator:<=(anyrange,anyrange) operator_slug:op-3c3d-anyrange-anyrange purpose:search result_type:bool right_type:anyrange sort_family: sort_family_slug: strategy:21], map[description:greater than family:range_inclusion_ops family_slug:family-brin-range_inclusion_ops left_type:anyrange method:brin operator:>(anyrange,anyrange) operator_slug:op-3e-anyrange-anyrange purpose:search result_type:bool right_type:anyrange sort_family: sort_family_slug: strategy:22], map[description:greater than or equal family:range_inclusion_ops family_slug:family-brin-range_inclusion_ops left_type:anyrange method:brin operator:>=(anyrange,anyrange) operator_slug:op-3e3d-anyrange-anyrange purpose:search result_type:bool right_type:anyrange sort_family: sort_family_slug: strategy:23]
support functions
map[family:range_inclusion_ops family_slug:family-brin-range_inclusion_ops function:brin_inclusion_opcinfo(internal) left_type:anyrange method:brin number:1 result_type:internal right_type:anyrange], map[family:range_inclusion_ops family_slug:family-brin-range_inclusion_ops function:brin_inclusion_add_value(internal,internal,internal,internal) left_type:anyrange method:brin number:2 result_type:bool right_type:anyrange], map[family:range_inclusion_ops family_slug:family-brin-range_inclusion_ops function:brin_inclusion_consistent(internal,internal,internal) left_type:anyrange method:brin number:3 result_type:bool right_type:anyrange], map[family:range_inclusion_ops family_slug:family-brin-range_inclusion_ops function:brin_inclusion_union(internal,internal,internal) left_type:anyrange method:brin number:4 result_type:bool right_type:anyrange], map[family:range_inclusion_ops family_slug:family-brin-range_inclusion_ops function:range_merge(anyrange,anyrange) left_type:anyrange method:brin number:11 result_type:anyrange right_type:anyrange], map[family:range_inclusion_ops family_slug:family-brin-range_inclusion_ops function:range_contains(anyrange,anyrange) left_type:anyrange method:brin number:13 result_type:bool right_type:anyrange], map[family:range_inclusion_ops family_slug:family-brin-range_inclusion_ops function:isempty(anyrange) left_type:anyrange method:brin number:14 result_type:bool right_type:anyrange]
来源引用
- Matching PostgreSQL source archive
- PostgreSQL 18 English manual: indexes-opclass.html
- PostgreSQL 18 English manual: catalog-pg-opclass.html
- PostgreSQL 18 English manual: catalog-pg-amop.html
- PostgreSQL 18 English manual: catalog-pg-amproc.html
- 固定 PostgreSQL 源码归档
定义来源
center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f
正文语言: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f