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

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

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

brin/timestamp_minmax_ops (class)

timestamp_minmax_ops 是 brin 的运算符类。

当前查看 PostgreSQL 18。

中文定义与说明

timestamp_minmax_ops 是 brin 的运算符类。

名称
timestamp_minmax_ops
运算符族
datetime_minmax_ops
索引访问方法
brin
默认类
是
存储键类型
timestamp
输入类型
timestamp

策略运算符

策略编号用途运算符左操作数类型右操作数类型排序运算符族
1搜索<(timestamp,timestamp)timestamptimestamp
2搜索<=(timestamp,timestamp)timestamptimestamp
3搜索=(timestamp,timestamp)timestamptimestamp
4搜索>=(timestamp,timestamp)timestamptimestamp
5搜索>(timestamp,timestamp)timestamptimestamp
1搜索<(timestamp,date)timestampdate
2搜索<=(timestamp,date)timestampdate
3搜索=(timestamp,date)timestampdate
4搜索>=(timestamp,date)timestampdate
5搜索>(timestamp,date)timestampdate
1搜索<(timestamp,timestamptz)timestamptimestamptz
2搜索<=(timestamp,timestamptz)timestamptimestamptz
3搜索=(timestamp,timestamptz)timestamptimestamptz
4搜索>=(timestamp,timestamptz)timestamptimestamptz
5搜索>(timestamp,timestamptz)timestamptimestamptz
1搜索<(date,date)datedate
2搜索<=(date,date)datedate
3搜索=(date,date)datedate
4搜索>=(date,date)datedate
5搜索>(date,date)datedate
1搜索<(date,timestamp)datetimestamp
2搜索<=(date,timestamp)datetimestamp
3搜索=(date,timestamp)datetimestamp
4搜索>=(date,timestamp)datetimestamp
5搜索>(date,timestamp)datetimestamp
1搜索<(date,timestamptz)datetimestamptz
2搜索<=(date,timestamptz)datetimestamptz
3搜索=(date,timestamptz)datetimestamptz
4搜索>=(date,timestamptz)datetimestamptz
5搜索>(date,timestamptz)datetimestamptz
1搜索<(timestamptz,date)timestamptzdate
2搜索<=(timestamptz,date)timestamptzdate
3搜索=(timestamptz,date)timestamptzdate
4搜索>=(timestamptz,date)timestamptzdate
5搜索>(timestamptz,date)timestamptzdate
1搜索<(timestamptz,timestamp)timestamptztimestamp
2搜索<=(timestamptz,timestamp)timestamptztimestamp
3搜索=(timestamptz,timestamp)timestamptztimestamp
4搜索>=(timestamptz,timestamp)timestamptztimestamp
5搜索>(timestamptz,timestamp)timestamptztimestamp
1搜索<(timestamptz,timestamptz)timestamptztimestamptz
2搜索<=(timestamptz,timestamptz)timestamptztimestamptz
3搜索=(timestamptz,timestamptz)timestamptztimestamptz
4搜索>=(timestamptz,timestamptz)timestamptztimestamptz
5搜索>(timestamptz,timestamptz)timestamptztimestamptz

支持函数

支持函数编号实现函数左操作数类型右操作数类型结果类型
1brin_minmax_opcinfo(internal)timestamptimestampinternal
2brin_minmax_add_value(internal,internal,internal,internal)timestamptimestampbool
3brin_minmax_consistent(internal,internal,internal)timestamptimestampbool
4brin_minmax_union(internal,internal,internal)timestamptimestampbool
1brin_minmax_opcinfo(internal)timestamptztimestamptzinternal
2brin_minmax_add_value(internal,internal,internal,internal)timestamptztimestamptzbool
3brin_minmax_consistent(internal,internal,internal)timestamptztimestamptzbool
4brin_minmax_union(internal,internal,internal)timestamptztimestamptzbool
1brin_minmax_opcinfo(internal)datedateinternal
2brin_minmax_add_value(internal,internal,internal,internal)datedatebool
3brin_minmax_consistent(internal,internal,internal)datedatebool
4brin_minmax_union(internal,internal,internal)datedatebool

同版本中文手册节选

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

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

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

下面的查询会显示所有已定义的操作符类：

查看完整中文手册与上下文。

说明

timestamp_minmax_ops 是 brin 的运算符类。

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

用法

brin/timestamp_minmax_ops

操作符类与家族

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

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

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

家族中的操作符策略

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

家族支持函数

支持函数编号左侧类型右侧类型函数签名返回类型
1timestamptimestampbrin_minmax_opcinfo(internal)internal
2timestamptimestampbrin_minmax_add_value(internal,internal,internal,internal)bool
3timestamptimestampbrin_minmax_consistent(internal,internal,internal)bool
4timestamptimestampbrin_minmax_union(internal,internal,internal)bool
1timestamptztimestamptzbrin_minmax_opcinfo(internal)internal
2timestamptztimestamptzbrin_minmax_add_value(internal,internal,internal,internal)bool
3timestamptztimestamptzbrin_minmax_consistent(internal,internal,internal)bool
4timestamptztimestamptzbrin_minmax_union(internal,internal,internal)bool
1datedatebrin_minmax_opcinfo(internal)internal
2datedatebrin_minmax_add_value(internal,internal,internal,internal)bool
3datedatebrin_minmax_consistent(internal,internal,internal)bool
4datedatebrin_minmax_union(internal,internal,internal)bool

本家族的操作符类

操作符类输入类型键类型默认值
date_minmax_opsdatedate是
timestamp_minmax_opstimestamptimestamp是
timestamptz_minmax_opstimestamptztimestamptz是

相关条目

文档与源码

来源构建
版本
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": "datetime_minmax_ops",
       "function": "brin_minmax_opcinfo(internal)",
-      "left_type": "date",
+      "left_type": "timestamp",
       "method": "brin",
       "number": "1",
       "result_type": "internal",
@@ -508,7 +508,7 @@
     {
       "family": "datetime_minmax_ops",
       "function": "brin_minmax_opcinfo(internal)",
-      "left_type": "date",
+      "left_type": "timestamptz",
       "method": "brin",
       "number": "1",
       "result_type": "internal",
@@ -516,287 +516,71 @@
     },
     {
       "family": "datetime_minmax_ops",
-      "function": "brin_minmax_opcinfo(internal)",
-      "left_type": "timestamp",
-      "method": "brin",
-      "number": "1",
-      "result_type": "internal",
+      "function": "brin_minmax_add_value(internal,internal,internal,internal)",
+      "left_type": "date",
+      "method": "brin",
+      "number": "2",
+      "result_type": "bool",
       "right_type": "date"
     },
     {
       "family": "datetime_minmax_ops",
-      "function": "brin_minmax_opcinfo(internal)",
-      "left_type": "timestamp",
-      "method": "brin",
-      "number": "1",
-      "result_type": "internal",
+      "function": "brin_minmax_add_value(internal,internal,internal,internal)",
+      "left_type": "timestamp",
+      "method": "brin",
+      "number": "2",
+      "result_type": "bool",
       "right_type": "timestamp"
     },
     {
       "family": "datetime_minmax_ops",
-      "function": "brin_minmax_opcinfo(internal)",
-      "left_type": "timestamp",
-      "method": "brin",
-      "number": "1",
-      "result_type": "internal",
+      "function": "brin_minmax_add_value(internal,internal,internal,internal)",
+      "left_type": "timestamptz",
+      "method": "brin",
+      "number": "2",
+      "result_type": "bool",
       "right_type": "timestamptz"
     },
     {
       "family": "datetime_minmax_ops",
-      "function": "brin_minmax_opcinfo(internal)",
-      "left_type": "timestamptz",
-      "method": "brin",
-      "number": "1",
-      "result_type": "internal",
+      "function": "brin_minmax_consistent(internal,internal,internal)",
+      "left_type": "date",
+      "method": "brin",
+      "number": "3",
+      "result_type": "bool",
       "right_type": "date"
     },
     {
       "family": "datetime_minmax_ops",
-      "function": "brin_minmax_opcinfo(internal)",
-      "left_type": "timestamptz",
-      "method": "brin",
-      "number": "1",
-      "result_type": "internal",
+      "function": "brin_minmax_consistent(internal,internal,internal)",
+      "left_type": "timestamp",
+      "method": "brin",
+      "number": "3",
+      "result_type": "bool",
       "right_type": "timestamp"
     },
     {
       "family": "datetime_minmax_ops",
-      "function": "brin_minmax_opcinfo(internal)",
-      "left_type": "timestamptz",
-      "method": "brin",
-      "number": "1",
-      "result_type": "internal",
+      "function": "brin_minmax_consistent(internal,internal,internal)",
+      "left_type": "timestamptz",
+      "method": "brin",
+      "number": "3",
+      "result_type": "bool",
       "right_type": "timestamptz"
     },
     {
       "family": "datetime_minmax_ops",
-      "function": "brin_minmax_add_value(internal,internal,internal,internal)",
-      "left_type": "date",
-      "method": "brin",
-      "number": "2",
+      "function": "brin_minmax_union(internal,internal,internal)",
+      "left_type": "date",
+      "method": "brin",
+      "number": "4",
       "result_type": "bool",
       "right_type": "date"
     },
     {
       "family": "datetime_minmax_ops",
-      "function": "brin_minmax_add_value(internal,internal,internal,internal)",
-      "left_type": "date",
-      "method": "brin",
-      "number": "2",
-      "result_type": "bool",
-      "right_type": "timestamp"
-    },
-    {
-      "family": "datetime_minmax_ops",
-      "function": "brin_minmax_add_value(internal,internal,internal,internal)",
-      "left_type": "date",
-      "method": "brin",
-      "number": "2",
-      "result_type": "bool",
-      "right_type": "timestamptz"
-    },
-    {
-      "family": "datetime_minmax_ops",
-      "function": "brin_minmax_add_value(internal,internal,internal,internal)",
-      "left_type": "timestamp",
-      "method": "brin",
-      "number": "2",
-      "result_type": "bool",
-      "right_type": "date"
-    },
-    {
-      "family": "datetime_minmax_ops",
-      "function": "brin_minmax_add_value(internal,internal,internal,internal)",
-      "left_type": "timestamp",
-      "method": "brin",
-      "number": "2",
-      "result_type": "bool",
-      "right_type": "timestamp"
-    },
-    {
-      "family": "datetime_minmax_ops",
-      "function": "brin_minmax_add_value(internal,internal,internal,internal)",
-      "left_type": "timestamp",
-      "method": "brin",
-      "number": "2",
-      "result_type": "bool",
-      "right_type": "timestamptz"
-    },
-    {
-      "family": "datetime_minmax_ops",
-      "function": "brin_minmax_add_value(internal,internal,internal,internal)",
-      "left_type": "timestamptz",
-      "method": "brin",
-      "number": "2",
-      "result_type": "bool",
-      "right_type": "date"
-    },
-    {
-      "family": "datetime_minmax_ops",
-      "function": "brin_minmax_add_value(internal,internal,internal,internal)",
-      "left_type": "timestamptz",
-      "method": "brin",
-      "number": "2",
-      "result_type": "bool",
-      "right_type": "timestamp"
-    },
-    {
-      "family": "datetime_minmax_ops",
-      "function": "brin_minmax_add_value(internal,internal,internal,internal)",
-      "left_type": "timestamptz",
-      "method": "brin",
-      "number": "2",
-      "result_type": "bool",
-      "right_type": "timestamptz"
-    },
-    {
-      "family": "datetime_minmax_ops",
-      "function": "brin_minmax_consistent(internal,internal,internal)",
-      "left_type": "date",
-      "method": "brin",
-      "number": "3",
-      "result_type": "bool",
-      "right_type": "date"
-    },
-    {
-      "family": "datetime_minmax_ops",
-      "function": "brin_minmax_consistent(internal,internal,internal)",
-      "left_type": "date",
-      "method": "brin",
-      "number": "3",
-      "result_type": "bool",
-      "right_type": "timestamp"
-    },
-    {
-      "family": "datetime_minmax_ops",
-      "function": "brin_minmax_consistent(internal,internal,internal)",
-      "left_type": "date",
-      "method": "brin",
-      "number": "3",
-      "result_type": "bool",
-      "right_type": "timestamptz"
-    },
-    {
-      "family": "datetime_minmax_ops",
-      "function": "brin_minmax_consistent(internal,internal,internal)",
-      "left_type": "timestamp",
-      "method": "brin",
-      "number": "3",
-      "result_type": "bool",
-      "right_type": "date"
-    },
-    {
-      "family": "datetime_minmax_ops",
-      "function": "brin_minmax_consistent(internal,internal,internal)",
-      "left_type": "timestamp",
-      "method": "brin",
-      "number": "3",
-      "result_type": "bool",
-      "right_type": "timestamp"
-    },
-    {
-      "family": "datetime_minmax_ops",
-      "function": "brin_minmax_consistent(internal,internal,internal)",
-      "left_type": "timestamp",
-      "method": "brin",
-      "number": "3",
-      "result_type": "bool",
-      "right_type": "timestamptz"
-    },
-    {
-      "family": "datetime_minmax_ops",
-      "function": "brin_minmax_consistent(internal,internal,internal)",
-      "left_type": "timestamptz",
-      "method": "brin",
-      "number": "3",
-      "result_type": "bool",
-      "right_type": "date"
-    },
-    {
-      "family": "datetime_minmax_ops",
-      "function": "brin_minmax_consistent(internal,internal,internal)",
-      "left_type": "timestamptz",
-      "method": "brin",
-      "number": "3",
-      "result_type": "bool",
-      "right_type": "timestamp"
-    },
-    {
-      "family": "datetime_minmax_ops",
-      "function": "brin_minmax_consistent(internal,internal,internal)",
-      "left_type": "timestamptz",
-      "method": "brin",
-      "number": "3",
-      "result_type": "bool",
-      "right_type": "timestamptz"
-    },
-    {
-      "family": "datetime_minmax_ops",
       "function": "brin_minmax_union(internal,internal,internal)",
-      "left_type": "date",
-      "method": "brin",
-      "number": "4",
-      "result_type": "bool",
-      "right_type": "date"
-    },
-    {
-      "family": "datetime_minmax_ops",
-      "function": "brin_minmax_union(internal,internal,internal)",
-      "left_type": "date",
-      "method": "brin",
-      "number": "4",
-      "result_type": "bool",
-      "right_type": "timestamp"
-    },
-    {
-      "family": "datetime_minmax_ops",
-      "function": "brin_minmax_union(internal,internal,internal)",
-      "left_type": "date",
-      "method": "brin",
-      "number": "4",
-      "result_type": "bool",
-      "right_type": "timestamptz"
-    },
-    {
-      "family": "datetime_minmax_ops",
-      "function": "brin_minmax_union(internal,internal,internal)",
-      "left_type": "timestamp",
-      "method": "brin",
-      "number": "4",
-      "result_type": "bool",
-      "right_type": "date"
-    },
-    {
-      "family": "datetime_minmax_ops",
-      "function": "brin_minmax_union(internal,internal,internal)",
-      "left_type": "timestamp",
-      "method": "brin",
-      "number": "4",
-      "result_type": "bool",
-      "right_type": "timestamp"
-    },
-    {
-      "family": "datetime_minmax_ops",
-      "function": "brin_minmax_union(internal,internal,internal)",
-      "left_type": "timestamp",
-      "method": "brin",
-      "number": "4",
-      "result_type": "bool",
-      "right_type": "timestamptz"
-    },
-    {
-      "family": "datetime_minmax_ops",
-      "function": "brin_minmax_union(internal,internal,internal)",
-      "left_type": "timestamptz",
-      "method": "brin",
-      "number": "4",
-      "result_type": "bool",
-      "right_type": "date"
-    },
-    {
-      "family": "datetime_minmax_ops",
-      "function": "brin_minmax_union(internal,internal,internal)",
-      "left_type": "timestamptz",
+      "left_type": "timestamp",
       "method": "brin",
       "number": "4",
       "result_type": "bool",

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

相关条目

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