gist/box_ops (class)
GiST operator class for box; member of box_ops.
当前阅读 PG 18·选择有来源记录的版本
此版本暂无所选语言的定义,以下显示原始英文内容。
- Object kind
- Operator class
- Index AM
- GiST
- Input type
- box
- Stored key type
- Same as input type (catalog zero)
- Default class
- yes
- aliases
- box_ops, gist/box_ops
- classes
- map[default:t family:box_ops family_slug:family-gist-box_ops input_type:box key_type:none method:gist name:box_ops slug:class-gist-box_ops source_oid:]
- signature
- gist/box_ops
- source oid
- 未知
版本定义 PG 18
GiST operator class for box; member of box_ops.
Family operator strategies
| Operator overload | Strategy | Purpose | Ordering family | Membership scope | Source description |
|---|---|---|---|---|---|
| <<(box,box) | 1 | search | Class input pair | is left of | |
| &<(box,box) | 2 | search | Class input pair | overlaps or is left of | |
| &&(box,box) | 3 | search | Class input pair | overlaps | |
| &>(box,box) | 4 | search | Class input pair | overlaps or is right of | |
| >>(box,box) | 5 | search | Class input pair | is right of | |
| ~=(box,box) | 6 | search | Class input pair | same as | |
| @>(box,box) | 7 | search | Class input pair | contains | |
| <@(box,box) | 8 | search | Class input pair | is contained by | |
| &<|(box,box) | 9 | search | Class input pair | overlaps or is below | |
| <<|(box,box) | 10 | search | Class input pair | is below | |
| |>>(box,box) | 11 | search | Class input pair | is above | |
| |&>(box,box) | 12 | search | Class input pair | overlaps or is above | |
| <->(box,point) | 15 | ordering | float_ops | Family member | distance between |
Family support functions
| Support number | Left type | Right type | Function signature | Result type |
|---|---|---|---|---|
| 1 | box | box | gist_box_consistent(internal,box,int2,oid,internal) | bool |
| 2 | box | box | gist_box_union(internal,internal) | box |
| 5 | box | box | gist_box_penalty(internal,internal,internal) | internal |
| 6 | box | box | gist_box_picksplit(internal,internal) | internal |
| 7 | box | box | gist_box_same(box,box,internal) | internal |
| 8 | box | box | gist_box_distance(internal,box,int2,oid,internal) | float8 |
| 12 | any | any | gist_translate_cmptype_common(int4) | int2 |
Classes in this family
比较版本
完整来源事实
class
{"default":"t","family":"box_ops","input_type":"box","key_type":"none","method":"gist","name":"box_ops"}operators
map[description:is left of family:box_ops family_slug:family-gist-box_ops left_type:box method:gist 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_ops family_slug:family-gist-box_ops left_type:box method:gist 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_ops family_slug:family-gist-box_ops left_type:box method:gist 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_ops family_slug:family-gist-box_ops left_type:box method:gist 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_ops family_slug:family-gist-box_ops left_type:box method:gist 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_ops family_slug:family-gist-box_ops left_type:box method:gist 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_ops family_slug:family-gist-box_ops left_type:box method:gist 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_ops family_slug:family-gist-box_ops left_type:box method:gist 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_ops family_slug:family-gist-box_ops left_type:box method:gist 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_ops family_slug:family-gist-box_ops left_type:box method:gist 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_ops family_slug:family-gist-box_ops left_type:box method:gist 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_ops family_slug:family-gist-box_ops left_type:box method:gist 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:distance between family:box_ops family_slug:family-gist-box_ops left_type:box method:gist operator:<->(box,point) operator_slug:op-3c2d3e-box-point purpose:ordering result_type:float8 right_type:point sort_family:float_ops sort_family_slug:family-btree-float_ops strategy:15]
support functions
map[family:box_ops family_slug:family-gist-box_ops function:gist_box_consistent(internal,box,int2,oid,internal) left_type:box method:gist number:1 result_type:bool right_type:box], map[family:box_ops family_slug:family-gist-box_ops function:gist_box_union(internal,internal) left_type:box method:gist number:2 result_type:box right_type:box], map[family:box_ops family_slug:family-gist-box_ops function:gist_box_penalty(internal,internal,internal) left_type:box method:gist number:5 result_type:internal right_type:box], map[family:box_ops family_slug:family-gist-box_ops function:gist_box_picksplit(internal,internal) left_type:box method:gist number:6 result_type:internal right_type:box], map[family:box_ops family_slug:family-gist-box_ops function:gist_box_same(box,box,internal) left_type:box method:gist number:7 result_type:internal right_type:box], map[family:box_ops family_slug:family-gist-box_ops function:gist_box_distance(internal,box,int2,oid,internal) left_type:box method:gist number:8 result_type:float8 right_type:box], map[family:box_ops family_slug:family-gist-box_ops function:gist_translate_cmptype_common(int4) left_type:any method:gist number:12 result_type:int2 right_type:any]
来源引用
- 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