Built-in Operator Classes
Built-in Operator Classes
The core PostgreSQL distribution includes the GIN operator classes shown in Built-in GIN Operator Classes. (Some of the optional modules described in Additional Supplied Modules and Extensions provide additional GIN operator classes.)
Table: Built-in GIN 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 type jsonb, jsonb_ops is the default. jsonb_path_ops supports fewer operators but offers better performance for those operators. See jsonb Indexing for details.