brin/box_inclusion_ops (class)

BRIN operator class for box; member of box_inclusion_ops.

Reading PG 18·Select a recorded version

Object kind: Operator class
Index AM: BRIN
Input type: box
Stored key type: box
Default class: yes
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: Unknown

Definition PG 18

BRIN operator class for box; member of box_inclusion_ops.

Family operator strategies

Operator overload	Strategy	Purpose	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)	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

Compare versions

Complete source facts

class

{"default":"t","family":"box_inclusion_ops","input_type":"box","key_type":"box","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]

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f