PostgreSQL

62.2. Built-in Operator Classes
Prev	Up	Chapter 62. GiST Indexes	Home	Next

62.2. Built-in Operator Classes

The core PostgreSQL distribution includes the GiST operator classes shown in Table 62.1. (Some of the optional modules described in Appendix F provide additional GiST operator classes.)

Table 62.1. Built-in GiST Operator Classes

Name Indexed Data Type Indexable Operators Ordering Operators

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`	`@@`

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

Prev	Up	Next
62.1. Introduction	Home	62.3. Extensibility

62.1. Introduction

Home

62.3. Extensibility