70.2. Built-in Operator Classes#
The corePostgreSQL distribution includes theGIN operator classes shown inTable 70.1. (Some of the optional modules described inAppendix F provide additionalGIN operator classes.) Table 70.1. Built-inGIN Operator Classes Of the two operator classes for typeName 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)jsonb,jsonb_ops is the default.jsonb_path_ops supports fewer operators but offers better performance for those operators. SeeSection 8.14.4 for details.