67.2. Built-in Operator Classes
The core PostgreSQL distribution includes the BRIN operator classes shown in Table 67.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 67.1. Built-in BRIN Operator Classes
Name | Indexed Data Type | Indexable Operators |
---|---|---|
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
|
any range type
|
<<
&<
&&
&>
>>
@>
<@
-|-
=
<
<=
=
>
>=
|
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
|
<
<=
=
>=
>
|