1 of 1

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

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);

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

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);

&& &> &< `&<

`>> << `<<

`<@ @> @ `

>>`~ ~=

&& &> &< `&<

`>> << `<<

`<@ @> @ `

>>`~ ~=

inet, cidr

&& >> >>= > >= <> << <<= < <= =

>> >^ << <@ <@ <@ <^ ~=

&& &> &< `&<

`>> << `<<

`<@ @> @ `

>>`~ ~=

&& &> &< >> << <@ `-

-`= @> @>

<@ @>