65.2. Built-in Operator Classes
The core PostgreSQL distribution includes the SP-GiST operator classes shown in Table 65.1 .
Table 65.1. Built-in SP-GiST Operator Classes
Name | Indexed Data Type | Indexable Operators |
---|---|---|
kd_point_ops
|
point
|
<<
<@
<^
>>
>^
~=
|
quad_point_ops
|
point
|
<<
<@
<^
>>
>^
~=
|
range_ops
|
any range type |
&&
&<
&>
-|-
<<
<@
=
>>
@>
|
box_ops
|
box
|
<<
&<
&&
&>
>>
~=
@>
<@
&<|
<<|
|>>
|&>
|
poly_ops
|
polygon
|
<<
&<
&&
&>
>>
~=
@>
<@
&<|
<<|
|>>
|&>
|
text_ops
|
text
|
<
<=
=
>
>=
~<=~
~<~
~>=~
~>~
^@
|
inet_ops
|
inet
,
cidr
|
&&
>>
>>=
>
>=
<>
<<
<<=
<
<=
=
|
Of the two operator classes for type
point
,
quad_point_ops
is the default.
kd_point_ops
supports the same operators but uses a different index data structure which
may offer better performance in some applications.