La distribution du noyau PostgreSQL inclut la classe d'opérateur BRIN montrée dans Tableau 67.1.
L'opérateur de classe minmax stocke les valeurs minimale et maximale apparaissant dans l'intervalle de la colonne indexée. L'opérateur de classe inclusion stocke une valeur qui est incluse dans les valeurs contenues dans l'intervalle de la colonne indexée.
Tableau 67.1. Classe d'opérateur BRIN intégrée
Nom | Type de données indexées | Opérateurs indexables |
---|---|---|
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 |
<
<=
=
>=
>
|
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 | tout type intervalle |
<<
&<
&&
&>
>>
@>
<@
-|-
=
<
<=
=
>
>=
|
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 |
<
<=
=
>=
>
|