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