64.2. Built-in Operator Classes
The corePostgres Pro distribution includes theGIN operator classes shown inTable 64.1. (Some of the optional modules described inAppendix F provide additionalGIN operator classes.)
Table 64.1. Built-inGIN Operator Classes
| Name | Indexable Operators |
|---|---|
array_ops | && (anyarray,anyarray) |
@> (anyarray,anyarray) | |
<@ (anyarray,anyarray) | |
= (anyarray,anyarray) | |
jsonb_ops | @> (jsonb,jsonb) |
@? (jsonb,jsonpath) | |
@@ (jsonb,jsonpath) | |
? (jsonb,text) | |
?| (jsonb,text[]) | |
?& (jsonb,text[]) | |
jsonb_path_ops | @> (jsonb,jsonb) |
@? (jsonb,jsonpath) | |
@@ (jsonb,jsonpath) | |
tsvector_ops | @@ (tsvector,tsquery) |
@@@ (tsvector,tsquery) |
Of the two operator classes for typejsonb,jsonb_ops is the default.jsonb_path_ops supports fewer operators but offers better performance for those operators. SeeSection 8.14.4 for details.