PostgreSQL

63.2. Built-in Operator Classes
Prev	Up	Chapter 63. SP-GiST Indexes	Home	Next

63.2. Built-in Operator Classes

The core PostgreSQL distribution includes the SP-GiST operator classes shown in Table 63.1.

Table 63.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`
`<<` `&<` `&&` `&>` `>>` `~=` `@>` `<@` `+&<	` `<<	` `
>>` `	&>+`	`text_ops`
`text`	`<` `<=` `=` `>` `>=` `~<=~` `~<~` `~>=~` `~>~`	`inet_ops`

kd_point_ops

point

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

quad_point_ops

point

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

range_ops

any range type

&& &< &> `+-

-` `<<` `<@` `=` `>>` `@>+`

box_ops

box

<< &< && &> >> ~= @> <@ `+&<

` `<<

` `

>>` `

&>+`

text_ops

text

< <= = > >= ~<=~ ~<~ ~>=~ ~>~

inet_ops

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
63.1. Introduction	Home	63.3. Extensibility

63.1. Introduction

Home

63.3. Extensibility