PostgreSQLのコア配布物には、表 65.1で示されるBRIN演算子クラスが含まれます。
minmax演算子クラスは、インデックスが貼られた列の範囲内に現れる最小値と最大値を格納します。 inclusion演算子クラスは、インデックスが貼られた列の範囲内に含まれる値を格納します。
表65.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 | <
<=
=
>=
>
|
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 | <
<=
=
>=
>
|
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 | <
<=
=
>=
>
|