spgist/box_ops (family)

SP-GiST operator family containing 1 classes, 13 operator strategies and 5 support functions in this source build.

当前阅读 PG 18·选择有来源记录的版本

此版本暂无所选语言的定义，以下显示原始英文内容。

Object kind: Operator family
Index AM: SP-GiST
aliases: box_ops, spgist/box_ops
classes: map[default:t family:box_ops family_slug:family-spgist-box_ops input_type:box key_type:none method:spgist name:box_ops slug:class-spgist-box_ops source_oid:]
signature: spgist/box_ops
source oid: 5000

版本定义 PG 18

SP-GiST operator family containing 1 classes, 13 operator strategies and 5 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)	15	ordering	float_ops	Family member	distance between

Family support functions

Support number	Left type	Right type	Function signature	Result type
1	box	box	spg_box_quad_config(internal,internal)	void
2	box	box	spg_box_quad_choose(internal,internal)	void
3	box	box	spg_box_quad_picksplit(internal,internal)	void
4	box	box	spg_box_quad_inner_consistent(internal,internal)	void
5	box	box	spg_box_quad_leaf_consistent(internal,internal)	bool

Classes in this family

Class	Input type	Key type	Default
box_ops	box	Same as input type	yes

比较版本

完整来源事实

family

{"method":"spgist","name":"box_ops"}

operators

map[description:is left of family:box_ops family_slug:family-spgist-box_ops left_type:box method:spgist 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-spgist-box_ops left_type:box method:spgist 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-spgist-box_ops left_type:box method:spgist 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-spgist-box_ops left_type:box method:spgist 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-spgist-box_ops left_type:box method:spgist 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-spgist-box_ops left_type:box method:spgist 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-spgist-box_ops left_type:box method:spgist 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-spgist-box_ops left_type:box method:spgist 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-spgist-box_ops left_type:box method:spgist 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-spgist-box_ops left_type:box method:spgist 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-spgist-box_ops left_type:box method:spgist 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-spgist-box_ops left_type:box method:spgist 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-spgist-box_ops left_type:box method:spgist 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-spgist-box_ops function:spg_box_quad_config(internal,internal) left_type:box method:spgist number:1 result_type:void right_type:box], map[family:box_ops family_slug:family-spgist-box_ops function:spg_box_quad_choose(internal,internal) left_type:box method:spgist number:2 result_type:void right_type:box], map[family:box_ops family_slug:family-spgist-box_ops function:spg_box_quad_picksplit(internal,internal) left_type:box method:spgist number:3 result_type:void right_type:box], map[family:box_ops family_slug:family-spgist-box_ops function:spg_box_quad_inner_consistent(internal,internal) left_type:box method:spgist number:4 result_type:void right_type:box], map[family:box_ops family_slug:family-spgist-box_ops function:spg_box_quad_leaf_consistent(internal,internal) left_type:box method:spgist number:5 result_type:bool right_type:box]

来源引用

完整定义与证据 JSON

定义来源

center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

正文语言: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f