PostgreSQL

65.2. Built-in Operator Classes
Prev	Up	Chapter 65. SP-GiST Indexes	Home	Next

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

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`	`&&` `>>` `>>=` `>` `>=` `<>` `<<` `<<=` `<` `<=` `=`

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 that may offer better performance in some applications.

Prev	Up	Next
65.1. Introduction	Home	65.3. Extensibility

65.1. Introduction

Home

65.3. Extensibility