PostgreSQL 9.5.3 文档 | |||
---|---|---|---|
上一页 | 上一级 | 章 62. BRIN索引 | 下一页 |
核心PostgreSQL发布包括 表 62-1 中显示的BRIN运算符类。
minmax运算符类存储出现在范围内的索引列中的最小值和最大值。 inclusion操作符类存储一个值,该值包括范围内的索引列中的值。
表 62-1. 内置 BRIN 操作符类
名称 | 索引的数据类型 | 可索引的操作符 |
---|---|---|
abstime_minmax_ops | abstime | < <= = >= > |
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 | < <= = >= > |
name_minmax_ops | name | < <= = >= > |
numeric_minmax_ops | numeric | < <= = >= > |
pg_lsn_minmax_ops | pg_lsn | < <= = >= > |
oid_minmax_ops | oid | < <= = >= > |
range_inclusion_ops | any range type | << &< && &> >> @> <@ -|- = < <= = > >= |
float4_minmax_ops | real | < <= = >= > |
reltime_minmax_ops | reltime | < <= = >= > |
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 | < <= = >= > |