↑↓ 选择 ↵ 打开 ⌫ 改范围 完整检索页

pgsql.cc 提供对 postgresql.org 官网内容的中文翻译，由 Pigsty 团队维护。

百科 / 运算符族 / BRIN 操作符类

brin/int4_minmax_ops (class)

int4 类型的 BRIN 操作符类，属于 integer_minmax_ops 家族。

当前查看 PostgreSQL 18.6。

说明

int4 类型的 BRIN 操作符类，属于 integer_minmax_ops 家族。

对象种类
操作符类
索引访问方法
BRIN
输入类型
int4
存储键类型
int4
默认操作符类
是

用法

brin/int4_minmax_ops

操作符类与家族

一个索引定义可以为索引的每一列指定一个 操作符类 。

操作符类标识该索引在该列上要使用哪些操作符。例如，类型 int4 上的一个 B-树索引会使用 int4_ops 类；这个操作符类包含对 int4 值进行比较所需的函数。实践中，列数据类型的默认操作符类通常已经足够。之所以存在操作符类，主要是因为对某些数据类型来说，可能存在多种有意义的索引行为。例如，我们可能希望按绝对值排序一种复数数据类型，也可能希望按实部排序。我们可以通过为该数据类型定义两个操作符类，并在创建索引时选择合适的那个来做到这一点。操作符类决定了基础排序顺序（之后还可以通过添加排序选项 COLLATE 、 ASC / DESC 和/或 NULLS FIRST / NULLS LAST 来修改）。

除了默认操作符类之外，还有一些内置操作符类：

家族中的操作符策略

操作符重载策略用途排序家族成员范围源码说明
<(int8,int8)1搜索家族成员小于
<=(int8,int8)2搜索家族成员小于等于
=(int8,int8)3搜索家族成员等于
>=(int8,int8)4搜索家族成员大于等于
>(int8,int8)5搜索家族成员大于
<(int8,int2)1搜索家族成员小于
<=(int8,int2)2搜索家族成员小于等于
=(int8,int2)3搜索家族成员等于
>=(int8,int2)4搜索家族成员大于等于
>(int8,int2)5搜索家族成员大于
<(int8,int4)1搜索家族成员小于
<=(int8,int4)2搜索家族成员小于等于
=(int8,int4)3搜索家族成员等于
>=(int8,int4)4搜索家族成员大于等于
>(int8,int4)5搜索家族成员大于
<(int2,int2)1搜索家族成员小于
<=(int2,int2)2搜索家族成员小于等于
=(int2,int2)3搜索家族成员等于
>=(int2,int2)4搜索家族成员大于等于
>(int2,int2)5搜索家族成员大于
<(int2,int8)1搜索家族成员小于
<=(int2,int8)2搜索家族成员小于等于
=(int2,int8)3搜索家族成员等于
>=(int2,int8)4搜索家族成员大于等于
>(int2,int8)5搜索家族成员大于
<(int2,int4)1搜索家族成员小于
<=(int2,int4)2搜索家族成员小于等于
=(int2,int4)3搜索家族成员等于
>=(int2,int4)4搜索家族成员大于等于
>(int2,int4)5搜索家族成员大于
<(int4,int4)1搜索操作符类输入类型对小于
<=(int4,int4)2搜索操作符类输入类型对小于等于
=(int4,int4)3搜索操作符类输入类型对等于
>=(int4,int4)4搜索操作符类输入类型对大于等于
>(int4,int4)5搜索操作符类输入类型对大于
<(int4,int2)1搜索家族成员小于
<=(int4,int2)2搜索家族成员小于等于
=(int4,int2)3搜索家族成员等于
>=(int4,int2)4搜索家族成员大于等于
>(int4,int2)5搜索家族成员大于
<(int4,int8)1搜索家族成员小于
<=(int4,int8)2搜索家族成员小于等于
=(int4,int8)3搜索家族成员等于
>=(int4,int8)4搜索家族成员大于等于
>(int4,int8)5搜索家族成员大于

家族支持函数

支持函数编号左侧类型右侧类型函数签名返回类型
1int8int8brin_minmax_opcinfo(internal)内部
2int8int8brin_minmax_add_value(internal,internal,internal,internal)bool
3int8int8brin_minmax_consistent(internal,internal,internal)bool
4int8int8brin_minmax_union(internal,internal,internal)bool
1int2int2brin_minmax_opcinfo(internal)内部
2int2int2brin_minmax_add_value(internal,internal,internal,internal)bool
3int2int2brin_minmax_consistent(internal,internal,internal)bool
4int2int2brin_minmax_union(internal,internal,internal)bool
1int4int4brin_minmax_opcinfo(internal)内部
2int4int4brin_minmax_add_value(internal,internal,internal,internal)bool
3int4int4brin_minmax_consistent(internal,internal,internal)bool
4int4int4brin_minmax_union(internal,internal,internal)bool

本家族的操作符类

操作符类输入类型键类型默认值
int8_minmax_opsint8int8是
int2_minmax_opsint2int2是
int4_minmax_opsint4int4是

相关条目

文档与源码

来源构建
版本
18.6
构建
https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2
来源指纹
555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

版本比较

PostgreSQL 13 → 14: 属性变化。

以下差异保留原始字段名与英文源描述。

--- PostgreSQL 13
+++ PostgreSQL 14
@@ -499,7 +499,7 @@
     {
       "family": "integer_minmax_ops",
       "function": "brin_minmax_opcinfo(internal)",
-      "left_type": "int2",
+      "left_type": "int4",
       "method": "brin",
       "number": "1",
       "result_type": "internal",
@@ -508,7 +508,7 @@
     {
       "family": "integer_minmax_ops",
       "function": "brin_minmax_opcinfo(internal)",
-      "left_type": "int2",
+      "left_type": "int8",
       "method": "brin",
       "number": "1",
       "result_type": "internal",
@@ -516,287 +516,71 @@
     },
     {
       "family": "integer_minmax_ops",
-      "function": "brin_minmax_opcinfo(internal)",
-      "left_type": "int4",
-      "method": "brin",
-      "number": "1",
-      "result_type": "internal",
+      "function": "brin_minmax_add_value(internal,internal,internal,internal)",
+      "left_type": "int2",
+      "method": "brin",
+      "number": "2",
+      "result_type": "bool",
       "right_type": "int2"
     },
     {
       "family": "integer_minmax_ops",
-      "function": "brin_minmax_opcinfo(internal)",
-      "left_type": "int4",
-      "method": "brin",
-      "number": "1",
-      "result_type": "internal",
+      "function": "brin_minmax_add_value(internal,internal,internal,internal)",
+      "left_type": "int4",
+      "method": "brin",
+      "number": "2",
+      "result_type": "bool",
       "right_type": "int4"
     },
     {
       "family": "integer_minmax_ops",
-      "function": "brin_minmax_opcinfo(internal)",
-      "left_type": "int4",
-      "method": "brin",
-      "number": "1",
-      "result_type": "internal",
+      "function": "brin_minmax_add_value(internal,internal,internal,internal)",
+      "left_type": "int8",
+      "method": "brin",
+      "number": "2",
+      "result_type": "bool",
       "right_type": "int8"
     },
     {
       "family": "integer_minmax_ops",
-      "function": "brin_minmax_opcinfo(internal)",
-      "left_type": "int8",
-      "method": "brin",
-      "number": "1",
-      "result_type": "internal",
+      "function": "brin_minmax_consistent(internal,internal,internal)",
+      "left_type": "int2",
+      "method": "brin",
+      "number": "3",
+      "result_type": "bool",
       "right_type": "int2"
     },
     {
       "family": "integer_minmax_ops",
-      "function": "brin_minmax_opcinfo(internal)",
-      "left_type": "int8",
-      "method": "brin",
-      "number": "1",
-      "result_type": "internal",
+      "function": "brin_minmax_consistent(internal,internal,internal)",
+      "left_type": "int4",
+      "method": "brin",
+      "number": "3",
+      "result_type": "bool",
       "right_type": "int4"
     },
     {
       "family": "integer_minmax_ops",
-      "function": "brin_minmax_opcinfo(internal)",
-      "left_type": "int8",
-      "method": "brin",
-      "number": "1",
-      "result_type": "internal",
+      "function": "brin_minmax_consistent(internal,internal,internal)",
+      "left_type": "int8",
+      "method": "brin",
+      "number": "3",
+      "result_type": "bool",
       "right_type": "int8"
     },
     {
       "family": "integer_minmax_ops",
-      "function": "brin_minmax_add_value(internal,internal,internal,internal)",
-      "left_type": "int2",
-      "method": "brin",
-      "number": "2",
+      "function": "brin_minmax_union(internal,internal,internal)",
+      "left_type": "int2",
+      "method": "brin",
+      "number": "4",
       "result_type": "bool",
       "right_type": "int2"
     },
     {
       "family": "integer_minmax_ops",
-      "function": "brin_minmax_add_value(internal,internal,internal,internal)",
-      "left_type": "int2",
-      "method": "brin",
-      "number": "2",
-      "result_type": "bool",
-      "right_type": "int4"
-    },
-    {
-      "family": "integer_minmax_ops",
-      "function": "brin_minmax_add_value(internal,internal,internal,internal)",
-      "left_type": "int2",
-      "method": "brin",
-      "number": "2",
-      "result_type": "bool",
-      "right_type": "int8"
-    },
-    {
-      "family": "integer_minmax_ops",
-      "function": "brin_minmax_add_value(internal,internal,internal,internal)",
-      "left_type": "int4",
-      "method": "brin",
-      "number": "2",
-      "result_type": "bool",
-      "right_type": "int2"
-    },
-    {
-      "family": "integer_minmax_ops",
-      "function": "brin_minmax_add_value(internal,internal,internal,internal)",
-      "left_type": "int4",
-      "method": "brin",
-      "number": "2",
-      "result_type": "bool",
-      "right_type": "int4"
-    },
-    {
-      "family": "integer_minmax_ops",
-      "function": "brin_minmax_add_value(internal,internal,internal,internal)",
-      "left_type": "int4",
-      "method": "brin",
-      "number": "2",
-      "result_type": "bool",
-      "right_type": "int8"
-    },
-    {
-      "family": "integer_minmax_ops",
-      "function": "brin_minmax_add_value(internal,internal,internal,internal)",
-      "left_type": "int8",
-      "method": "brin",
-      "number": "2",
-      "result_type": "bool",
-      "right_type": "int2"
-    },
-    {
-      "family": "integer_minmax_ops",
-      "function": "brin_minmax_add_value(internal,internal,internal,internal)",
-      "left_type": "int8",
-      "method": "brin",
-      "number": "2",
-      "result_type": "bool",
-      "right_type": "int4"
-    },
-    {
-      "family": "integer_minmax_ops",
-      "function": "brin_minmax_add_value(internal,internal,internal,internal)",
-      "left_type": "int8",
-      "method": "brin",
-      "number": "2",
-      "result_type": "bool",
-      "right_type": "int8"
-    },
-    {
-      "family": "integer_minmax_ops",
-      "function": "brin_minmax_consistent(internal,internal,internal)",
-      "left_type": "int2",
-      "method": "brin",
-      "number": "3",
-      "result_type": "bool",
-      "right_type": "int2"
-    },
-    {
-      "family": "integer_minmax_ops",
-      "function": "brin_minmax_consistent(internal,internal,internal)",
-      "left_type": "int2",
-      "method": "brin",
-      "number": "3",
-      "result_type": "bool",
-      "right_type": "int4"
-    },
-    {
-      "family": "integer_minmax_ops",
-      "function": "brin_minmax_consistent(internal,internal,internal)",
-      "left_type": "int2",
-      "method": "brin",
-      "number": "3",
-      "result_type": "bool",
-      "right_type": "int8"
-    },
-    {
-      "family": "integer_minmax_ops",
-      "function": "brin_minmax_consistent(internal,internal,internal)",
-      "left_type": "int4",
-      "method": "brin",
-      "number": "3",
-      "result_type": "bool",
-      "right_type": "int2"
-    },
-    {
-      "family": "integer_minmax_ops",
-      "function": "brin_minmax_consistent(internal,internal,internal)",
-      "left_type": "int4",
-      "method": "brin",
-      "number": "3",
-      "result_type": "bool",
-      "right_type": "int4"
-    },
-    {
-      "family": "integer_minmax_ops",
-      "function": "brin_minmax_consistent(internal,internal,internal)",
-      "left_type": "int4",
-      "method": "brin",
-      "number": "3",
-      "result_type": "bool",
-      "right_type": "int8"
-    },
-    {
-      "family": "integer_minmax_ops",
-      "function": "brin_minmax_consistent(internal,internal,internal)",
-      "left_type": "int8",
-      "method": "brin",
-      "number": "3",
-      "result_type": "bool",
-      "right_type": "int2"
-    },
-    {
-      "family": "integer_minmax_ops",
-      "function": "brin_minmax_consistent(internal,internal,internal)",
-      "left_type": "int8",
-      "method": "brin",
-      "number": "3",
-      "result_type": "bool",
-      "right_type": "int4"
-    },
-    {
-      "family": "integer_minmax_ops",
-      "function": "brin_minmax_consistent(internal,internal,internal)",
-      "left_type": "int8",
-      "method": "brin",
-      "number": "3",
-      "result_type": "bool",
-      "right_type": "int8"
-    },
-    {
-      "family": "integer_minmax_ops",
       "function": "brin_minmax_union(internal,internal,internal)",
-      "left_type": "int2",
-      "method": "brin",
-      "number": "4",
-      "result_type": "bool",
-      "right_type": "int2"
-    },
-    {
-      "family": "integer_minmax_ops",
-      "function": "brin_minmax_union(internal,internal,internal)",
-      "left_type": "int2",
-      "method": "brin",
-      "number": "4",
-      "result_type": "bool",
-      "right_type": "int4"
-    },
-    {
-      "family": "integer_minmax_ops",
-      "function": "brin_minmax_union(internal,internal,internal)",
-      "left_type": "int2",
-      "method": "brin",
-      "number": "4",
-      "result_type": "bool",
-      "right_type": "int8"
-    },
-    {
-      "family": "integer_minmax_ops",
-      "function": "brin_minmax_union(internal,internal,internal)",
-      "left_type": "int4",
-      "method": "brin",
-      "number": "4",
-      "result_type": "bool",
-      "right_type": "int2"
-    },
-    {
-      "family": "integer_minmax_ops",
-      "function": "brin_minmax_union(internal,internal,internal)",
-      "left_type": "int4",
-      "method": "brin",
-      "number": "4",
-      "result_type": "bool",
-      "right_type": "int4"
-    },
-    {
-      "family": "integer_minmax_ops",
-      "function": "brin_minmax_union(internal,internal,internal)",
-      "left_type": "int4",
-      "method": "brin",
-      "number": "4",
-      "result_type": "bool",
-      "right_type": "int8"
-    },
-    {
-      "family": "integer_minmax_ops",
-      "function": "brin_minmax_union(internal,internal,internal)",
-      "left_type": "int8",
-      "method": "brin",
-      "number": "4",
-      "result_type": "bool",
-      "right_type": "int2"
-    },
-    {
-      "family": "integer_minmax_ops",
-      "function": "brin_minmax_union(internal,internal,internal)",
-      "left_type": "int8",
+      "left_type": "int4",
       "method": "brin",
       "number": "4",
       "result_type": "bool",

比较已记录的接口与属性，排除来源指纹和构建元数据。某个样本中没有记录，不能据此判断实际引入或移除的版本。

相关条目

导出 JSON · 返回运算符族 · 收录范围为 PostgreSQL 10 至 20；最早采样版本不一定是实际引入版本。