The core PostgreSQL distribution includes the GiST operator classes shown in Table 65.1. (Some of the optional modules described in Appendix F provide additional GiST operator classes.)
Table 65.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);