| PostgreSQL 9.6.12 Documentation | |||
|---|---|---|---|
| Prev | Up | Chapter 64. BRIN Indexes | Next |
The core PostgreSQL distribution includes the BRIN operator classes shown in Table 64-1.
The minmax operator classes store the minimum and the maximum values appearing in the indexed column within the range. The inclusion operator classes store a value which includes the values in the indexed column within the range.
Table 64-1. Built-in BRIN Operator Classes
| Name | Indexed Data Type | Indexable Operators |
|---|---|---|
| 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 | < <= = >= > |