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
Last updated