| 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 | < <= = >= > |