Extending GiST

Of course, it is also possible to come up with your own operator classes. The following strategies are supported:

Operation

Strategy number

Strictly left of

1

Does not extend to right of

2

Overlaps

3

Does not extend to left of

4

Strictly right of

5

Same

6

Contains

7

Contained by

8

Does not extend above

9

Strictly below

10

Strictly above

11

Does not extend below

12

If you want to write operator classes for GiST, a couple of support functions have to be provided. In the case of a b-tree, there is only the same function - GiST indexes provide a lot more:

Function

Description

Support function number

consistent

The functions determine ...

Get Mastering PostgreSQL 10 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.