↑↓ 选择↵ 打开⌫ 切换范围完整搜索

PG.CENTER 连接 PostgreSQL 文档、百科与生态知识。由 Pigsty 维护。

Wiki / 操作符族

gist/range_ops (family)

GiST operator family containing 1 classes, 18 operator strategies and 7 support functions in this source build.

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

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

Object kind
Operator family
Index AM
GiST
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
3919

版本定义 PG 18

GiST operator family containing 1 classes, 18 operator strategies and 7 support functions in this source build.

Family operator strategies

Operator overloadStrategyPurposeOrdering familyMembership scopeSource description
<<(anyrange,anyrange)1searchFamily memberis left of
<<(anyrange,anymultirange)1searchFamily memberis left of
&<(anyrange,anyrange)2searchFamily memberoverlaps or is left of
&<(anyrange,anymultirange)2searchFamily memberoverlaps or is left of
&&(anyrange,anyrange)3searchFamily memberoverlaps
&&(anyrange,anymultirange)3searchFamily memberoverlaps
&>(anyrange,anyrange)4searchFamily memberoverlaps or is right of
&>(anyrange,anymultirange)4searchFamily memberoverlaps or is right of
>>(anyrange,anyrange)5searchFamily memberis right of
>>(anyrange,anymultirange)5searchFamily memberis right of
-|-(anyrange,anyrange)6searchFamily memberis adjacent to
-|-(anyrange,anymultirange)6searchFamily memberis adjacent to
@>(anyrange,anyrange)7searchFamily membercontains
@>(anyrange,anymultirange)7searchFamily membercontains
<@(anyrange,anyrange)8searchFamily memberis contained by
<@(anyrange,anymultirange)8searchFamily memberis contained by
@>(anyrange,anyelement)16searchFamily membercontains
=(anyrange,anyrange)18searchFamily memberequal

Family support functions

Support numberLeft typeRight typeFunction signatureResult type
1anyrangeanyrangerange_gist_consistent(internal,anyrange,int2,oid,internal)bool
2anyrangeanyrangerange_gist_union(internal,internal)anyrange
5anyrangeanyrangerange_gist_penalty(internal,internal,internal)internal
6anyrangeanyrangerange_gist_picksplit(internal,internal)internal
7anyrangeanyrangerange_gist_same(anyrange,anyrange,internal)internal
11anyrangeanyrangerange_sortsupport(internal)void
12anyanygist_translate_cmptype_common(int4)int2

Classes in this family

ClassInput typeKey typeDefault
range_opsanyrangeSame as input typeyes

比较版本

完整来源事实

family

{"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]

来源引用

完整定义与证据 JSON

定义来源

center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

正文语言: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f