The core PostgreSQL distribution includes the GiST operator classes shown in Table 62.1. (Some of the optional modules described in Appendix F provide additional GiST operator classes.)
Table 62.1. Built-in GiST Operator Classes
| Name | Indexed Data Type | Indexable Operators | Ordering Operators |
|---|---|---|---|
box_ops | box | &&
&>
&<
&<|
>>
<<
<<|
<@
@>
@
|&>
|>>
~
~=
| |
circle_ops | circle | &&
&>
&<
&<|
>>
<<
<<|
<@
@>
@
|&>
|>>
~
~=
| <->
|
inet_ops | inet, cidr | &&
>>
>>=
>
>=
<>
<<
<<=
<
<=
=
| |
point_ops | point | >>
>^
<<
<@
<@
<@
<^
~=
| <->
|
poly_ops | polygon | &&
&>
&<
&<|
>>
<<
<<|
<@
@>
@
|&>
|>>
~
~=
| <->
|
range_ops | any range type | &&
&>
&<
>>
<<
<@
-|-
=
@>
@>
| |
tsquery_ops | tsquery | <@
@>
| |
tsvector_ops | tsvector | @@
|
For historical reasons, the inet_ops operator class is
not the default class for types inet and cidr.
To use it, mention the class name in CREATE INDEX,
for example
CREATE INDEX ON my_table USING GIST (my_inet_column inet_ops);