62.2. Built-in Operator Classes
The corePostgreSQL distribution includes theGiST operator classes shown inTable 62.1. (Some of the optional modules described inAppendix F provide additionalGiST operator classes.) Table 62.1. Built-inGiST Operator Classes For historical reasons, theName 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
@@
inet_ops
operator class is not the default class for typesinet
andcidr
. To use it, mention the class name inCREATE INDEX
, for exampleCREATE INDEX ON my_table USING GIST (my_inet_column inet_ops);