历史版本。 PostgreSQL 13 已结束支持。 2025-11-13. 请参阅 当前版本手册.
67.2. 内置操作符类 #
核心 PostgreSQL 发行版包含表 67.1 中所示的 BRIN 操作符类。
minmax 操作符类存储该范围内索引列中出现的最小值和最大值。inclusion 操作符类存储一个能够包含该范围内索引列值的值。
表 67.1. 内置 BRIN 操作符类
| 名称 | 索引数据类型 | 可索引操作符 |
|---|---|---|
int8_minmax_ops | bigint |
<
<=
=
>=
>
|
bit_minmax_ops | bit |
<
<=
=
>=
>
|
varbit_minmax_ops | bit varying |
<
<=
=
>=
>
|
box_inclusion_ops | box | << &< && &> >> ~= @> <@ &<| <<| |>> |&> |
bytea_minmax_ops | bytea |
<
<=
=
>=
>
|
bpchar_minmax_ops | character |
<
<=
=
>=
>
|
char_minmax_ops | "char" |
<
<=
=
>=
>
|
date_minmax_ops | date |
<
<=
=
>=
>
|
float8_minmax_ops | double precision |
<
<=
=
>=
>
|
inet_minmax_ops | inet |
<
<=
=
>=
>
|
network_inclusion_ops | inet | && >>= <<= = >> << |
int4_minmax_ops | integer |
<
<=
=
>=
>
|
interval_minmax_ops | interval |
<
<=
=
>=
>
|
macaddr_minmax_ops | macaddr |
<
<=
=
>=
>
|
macaddr8_minmax_ops | macaddr8 |
<
<=
=
>=
>
|
name_minmax_ops | name |
<
<=
=
>=
>
|
numeric_minmax_ops | numeric |
<
<=
=
>=
>
|
pg_lsn_minmax_ops | pg_lsn |
<
<=
=
>=
>
|
oid_minmax_ops | oid |
<
<=
=
>=
>
|
range_inclusion_ops | 任意范围类型 | << &< && &> >> @> <@ -|- = < <= = > >= |
float4_minmax_ops | real |
<
<=
=
>=
>
|
int2_minmax_ops | smallint |
<
<=
=
>=
>
|
text_minmax_ops | text |
<
<=
=
>=
>
|
tid_minmax_ops | tid |
<
<=
=
>=
>
|
timestamp_minmax_ops | timestamp without time zone |
<
<=
=
>=
>
|
timestamptz_minmax_ops | timestamp with time zone |
<
<=
=
>=
>
|
time_minmax_ops | time without time zone |
<
<=
=
>=
>
|
timetz_minmax_ops | time with time zone |
<
<=
=
>=
>
|
uuid_minmax_ops | uuid |
<
<=
=
>=
>
|