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

NameIndexed Data TypeIndexable OperatorsOrdering 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);