gist/multirange_ops (class)

GiST operator class for anymultirange; member of multirange_ops.

Reading PG 18·Select a recorded version

Object kind: Operator class
Index AM: GiST
Input type: anymultirange
Stored key type: anyrange
Default class: yes
aliases: multirange_ops, gist/multirange_ops
classes: map[default:t family:multirange_ops family_slug:family-gist-multirange_ops input_type:anymultirange key_type:anyrange method:gist name:multirange_ops slug:class-gist-multirange_ops source_oid:]
signature: gist/multirange_ops
source oid: Unknown

Definition PG 18

GiST operator class for anymultirange; member of multirange_ops.

Family operator strategies

Operator overload	Strategy	Purpose	Membership scope	Source description
<<(anymultirange,anymultirange)	1	search	Class input pair	is left of
<<(anymultirange,anyrange)	1	search	Family member	is left of
&<(anymultirange,anymultirange)	2	search	Class input pair	overlaps or is left of
&<(anymultirange,anyrange)	2	search	Family member	overlaps or is left of
&&(anymultirange,anymultirange)	3	search	Class input pair	overlaps
&&(anymultirange,anyrange)	3	search	Family member	overlaps
&>(anymultirange,anymultirange)	4	search	Class input pair	overlaps or is right of
&>(anymultirange,anyrange)	4	search	Family member	overlaps or is right of
>>(anymultirange,anymultirange)	5	search	Class input pair	is right of
>>(anymultirange,anyrange)	5	search	Family member	is right of
-\|-(anymultirange,anymultirange)	6	search	Class input pair	is adjacent to
-\|-(anymultirange,anyrange)	6	search	Family member	is adjacent to
@>(anymultirange,anymultirange)	7	search	Class input pair	contains
@>(anymultirange,anyrange)	7	search	Family member	contains
<@(anymultirange,anymultirange)	8	search	Class input pair	is contained by
<@(anymultirange,anyrange)	8	search	Family member	is contained by
@>(anymultirange,anyelement)	16	search	Family member	contains
=(anymultirange,anymultirange)	18	search	Class input pair	equal

Family support functions

Support number	Left type	Right type	Function signature	Result type
1	anymultirange	anymultirange	multirange_gist_consistent(internal,anymultirange,int2,oid,internal)	bool
2	anymultirange	anymultirange	range_gist_union(internal,internal)	anyrange
3	anymultirange	anymultirange	multirange_gist_compress(internal)	internal
5	anymultirange	anymultirange	range_gist_penalty(internal,internal,internal)	internal
6	anymultirange	anymultirange	range_gist_picksplit(internal,internal)	internal
7	anymultirange	anymultirange	range_gist_same(anyrange,anyrange,internal)	internal
12	any	any	gist_translate_cmptype_common(int4)	int2

Classes in this family

Class	Input type	Key type	Default
multirange_ops	anymultirange	anyrange	yes

Compare versions

Complete source facts

class

{"default":"t","family":"multirange_ops","input_type":"anymultirange","key_type":"anyrange","method":"gist","name":"multirange_ops"}

operators

map[description:is left of family:multirange_ops family_slug:family-gist-multirange_ops left_type:anymultirange method:gist operator:<<(anymultirange,anymultirange) operator_slug:op-3c3c-anymultirange-anymultirange purpose:search result_type:bool right_type:anymultirange sort_family: sort_family_slug: strategy:1], map[description:is left of family:multirange_ops family_slug:family-gist-multirange_ops left_type:anymultirange method:gist operator:<<(anymultirange,anyrange) operator_slug:op-3c3c-anymultirange-anyrange purpose:search result_type:bool right_type:anyrange sort_family: sort_family_slug: strategy:1], map[description:overlaps or is left of family:multirange_ops family_slug:family-gist-multirange_ops left_type:anymultirange method:gist operator:&<(anymultirange,anymultirange) operator_slug:op-263c-anymultirange-anymultirange purpose:search result_type:bool right_type:anymultirange sort_family: sort_family_slug: strategy:2], map[description:overlaps or is left of family:multirange_ops family_slug:family-gist-multirange_ops left_type:anymultirange method:gist operator:&<(anymultirange,anyrange) operator_slug:op-263c-anymultirange-anyrange purpose:search result_type:bool right_type:anyrange sort_family: sort_family_slug: strategy:2], map[description:overlaps family:multirange_ops family_slug:family-gist-multirange_ops left_type:anymultirange method:gist operator:&&(anymultirange,anymultirange) operator_slug:op-2626-anymultirange-anymultirange purpose:search result_type:bool right_type:anymultirange sort_family: sort_family_slug: strategy:3], map[description:overlaps family:multirange_ops family_slug:family-gist-multirange_ops left_type:anymultirange method:gist operator:&&(anymultirange,anyrange) operator_slug:op-2626-anymultirange-anyrange purpose:search result_type:bool right_type:anyrange sort_family: sort_family_slug: strategy:3], map[description:overlaps or is right of family:multirange_ops family_slug:family-gist-multirange_ops left_type:anymultirange method:gist operator:&>(anymultirange,anymultirange) operator_slug:op-263e-anymultirange-anymultirange purpose:search result_type:bool right_type:anymultirange sort_family: sort_family_slug: strategy:4], map[description:overlaps or is right of family:multirange_ops family_slug:family-gist-multirange_ops left_type:anymultirange method:gist operator:&>(anymultirange,anyrange) operator_slug:op-263e-anymultirange-anyrange purpose:search result_type:bool right_type:anyrange sort_family: sort_family_slug: strategy:4], map[description:is right of family:multirange_ops family_slug:family-gist-multirange_ops left_type:anymultirange method:gist operator:>>(anymultirange,anymultirange) operator_slug:op-3e3e-anymultirange-anymultirange purpose:search result_type:bool right_type:anymultirange sort_family: sort_family_slug: strategy:5], map[description:is right of family:multirange_ops family_slug:family-gist-multirange_ops left_type:anymultirange method:gist operator:>>(anymultirange,anyrange) operator_slug:op-3e3e-anymultirange-anyrange purpose:search result_type:bool right_type:anyrange sort_family: sort_family_slug: strategy:5], map[description:is adjacent to family:multirange_ops family_slug:family-gist-multirange_ops left_type:anymultirange method:gist operator:-|-(anymultirange,anymultirange) operator_slug:op-2d7c2d-anymultirange-anymultirange purpose:search result_type:bool right_type:anymultirange sort_family: sort_family_slug: strategy:6], map[description:is adjacent to family:multirange_ops family_slug:family-gist-multirange_ops left_type:anymultirange method:gist operator:-|-(anymultirange,anyrange) operator_slug:op-2d7c2d-anymultirange-anyrange purpose:search result_type:bool right_type:anyrange sort_family: sort_family_slug: strategy:6], map[description:contains family:multirange_ops family_slug:family-gist-multirange_ops left_type:anymultirange method:gist operator:@>(anymultirange,anymultirange) operator_slug:op-403e-anymultirange-anymultirange purpose:search result_type:bool right_type:anymultirange sort_family: sort_family_slug: strategy:7], map[description:contains family:multirange_ops family_slug:family-gist-multirange_ops left_type:anymultirange method:gist operator:@>(anymultirange,anyrange) operator_slug:op-403e-anymultirange-anyrange purpose:search result_type:bool right_type:anyrange sort_family: sort_family_slug: strategy:7], map[description:is contained by family:multirange_ops family_slug:family-gist-multirange_ops left_type:anymultirange method:gist operator:<@(anymultirange,anymultirange) operator_slug:op-3c40-anymultirange-anymultirange purpose:search result_type:bool right_type:anymultirange sort_family: sort_family_slug: strategy:8], map[description:is contained by family:multirange_ops family_slug:family-gist-multirange_ops left_type:anymultirange method:gist operator:<@(anymultirange,anyrange) operator_slug:op-3c40-anymultirange-anyrange purpose:search result_type:bool right_type:anyrange sort_family: sort_family_slug: strategy:8], map[description:contains family:multirange_ops family_slug:family-gist-multirange_ops left_type:anymultirange method:gist operator:@>(anymultirange,anyelement) operator_slug:op-403e-anymultirange-anyelement purpose:search result_type:bool right_type:anyelement sort_family: sort_family_slug: strategy:16], map[description:equal family:multirange_ops family_slug:family-gist-multirange_ops left_type:anymultirange method:gist operator:=(anymultirange,anymultirange) operator_slug:op-3d-anymultirange-anymultirange purpose:search result_type:bool right_type:anymultirange sort_family: sort_family_slug: strategy:18]

support functions

map[family:multirange_ops family_slug:family-gist-multirange_ops function:multirange_gist_consistent(internal,anymultirange,int2,oid,internal) left_type:anymultirange method:gist number:1 result_type:bool right_type:anymultirange], map[family:multirange_ops family_slug:family-gist-multirange_ops function:range_gist_union(internal,internal) left_type:anymultirange method:gist number:2 result_type:anyrange right_type:anymultirange], map[family:multirange_ops family_slug:family-gist-multirange_ops function:multirange_gist_compress(internal) left_type:anymultirange method:gist number:3 result_type:internal right_type:anymultirange], map[family:multirange_ops family_slug:family-gist-multirange_ops function:range_gist_penalty(internal,internal,internal) left_type:anymultirange method:gist number:5 result_type:internal right_type:anymultirange], map[family:multirange_ops family_slug:family-gist-multirange_ops function:range_gist_picksplit(internal,internal) left_type:anymultirange method:gist number:6 result_type:internal right_type:anymultirange], map[family:multirange_ops family_slug:family-gist-multirange_ops function:range_gist_same(anyrange,anyrange,internal) left_type:anymultirange method:gist number:7 result_type:internal right_type:anymultirange], map[family:multirange_ops family_slug:family-gist-multirange_ops function:gist_translate_cmptype_common(int4) left_type:any method:gist number:12 result_type:int2 right_type:any]

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f