67.2. 内建操作符类

核心PostgreSQL发布包括了 表 67.1中所示的 BRIN操作符类。

minmax操作符类存储范围内被索引列中出现的最小和最大值。 inclusion操作符类存储包括了范围内被索引列中值的一个值。

表 67.1. 内建 BRIN 操作符类

名称被索引数据类型可索引操作符
int8_minmax_opsbigint < <= = >= >
bit_minmax_opsbit < <= = >= >
varbit_minmax_opsbit varying < <= = >= >
box_inclusion_opsbox << &< && &> >> ~= @> <@ &<| <<| |>> |&>
bytea_minmax_opsbytea < <= = >= >
bpchar_minmax_opscharacter < <= = >= >
char_minmax_ops"char" < <= = >= >
date_minmax_opsdate < <= = >= >
float8_minmax_opsdouble precision < <= = >= >
inet_minmax_opsinet < <= = >= >
network_inclusion_opsinet && >>= <<= = >> <<
int4_minmax_opsinteger < <= = >= >
interval_minmax_opsinterval < <= = >= >
macaddr_minmax_opsmacaddr < <= = >= >
macaddr8_minmax_opsmacaddr8 < <= = >= >
name_minmax_opsname < <= = >= >
numeric_minmax_opsnumeric < <= = >= >
pg_lsn_minmax_opspg_lsn < <= = >= >
oid_minmax_opsoid < <= = >= >
range_inclusion_opsany range type << &< && &> >> @> <@ -|- = < <= = > >=
float4_minmax_opsreal < <= = >= >
int2_minmax_opssmallint < <= = >= >
text_minmax_opstext < <= = >= >
tid_minmax_opstid < <= = >= >
timestamp_minmax_opstimestamp without time zone < <= = >= >
timestamptz_minmax_opstimestamp with time zone < <= = >= >
time_minmax_opstime without time zone < <= = >= >
timetz_minmax_opstime with time zone < <= = >= >
uuid_minmax_opsuuid < <= = >= >