65.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

kd_point_ops

point

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

quad_point_ops

point

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

range_ops

any range type

&& &< &> `-

-`<< <@ = >> @>

box_ops

box

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

``<<

>> ``

&>`

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

Last updated