gist/range_ops (class)

GiST operator class for anyrange; member of range_ops.

Reading PG 18·Select a recorded version

Object kind: Operator class
Index AM: GiST
Input type: anyrange
Stored key type: Same as input type (catalog zero)
Default class: yes
aliases: range_ops, gist/range_ops
classes: map[default:t family:range_ops family_slug:family-gist-range_ops input_type:anyrange key_type:none method:gist name:range_ops slug:class-gist-range_ops source_oid:]
signature: gist/range_ops
source oid: Unknown

Definition PG 18

GiST operator class for anyrange; member of range_ops.

Family operator strategies

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

Family support functions

Support number	Left type	Right type	Function signature	Result type
1	anyrange	anyrange	range_gist_consistent(internal,anyrange,int2,oid,internal)	bool
2	anyrange	anyrange	range_gist_union(internal,internal)	anyrange
5	anyrange	anyrange	range_gist_penalty(internal,internal,internal)	internal
6	anyrange	anyrange	range_gist_picksplit(internal,internal)	internal
7	anyrange	anyrange	range_gist_same(anyrange,anyrange,internal)	internal
11	anyrange	anyrange	range_sortsupport(internal)	void
12	any	any	gist_translate_cmptype_common(int4)	int2

Classes in this family

Class	Input type	Key type	Default
range_ops	anyrange	Same as input type	yes

Compare versions

Complete source facts

class

{"default":"t","family":"range_ops","input_type":"anyrange","key_type":"none","method":"gist","name":"range_ops"}

operators

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

support functions

map[family:range_ops family_slug:family-gist-range_ops function:range_gist_consistent(internal,anyrange,int2,oid,internal) left_type:anyrange method:gist number:1 result_type:bool right_type:anyrange], map[family:range_ops family_slug:family-gist-range_ops function:range_gist_union(internal,internal) left_type:anyrange method:gist number:2 result_type:anyrange right_type:anyrange], map[family:range_ops family_slug:family-gist-range_ops function:range_gist_penalty(internal,internal,internal) left_type:anyrange method:gist number:5 result_type:internal right_type:anyrange], map[family:range_ops family_slug:family-gist-range_ops function:range_gist_picksplit(internal,internal) left_type:anyrange method:gist number:6 result_type:internal right_type:anyrange], map[family:range_ops family_slug:family-gist-range_ops function:range_gist_same(anyrange,anyrange,internal) left_type:anyrange method:gist number:7 result_type:internal right_type:anyrange], map[family:range_ops family_slug:family-gist-range_ops function:range_sortsupport(internal) left_type:anyrange method:gist number:11 result_type:void right_type:anyrange], map[family:range_ops family_slug:family-gist-range_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