| PostgreSQL 9.4.1 Documentation | |||
|---|---|---|---|
| Prev | Up | Chapter 58. GIN Indexes | Next |
58.2. Built-in Operator Classes
The corePostgreSQL distribution includes theGIN operator classes shown inTable 58-1. (Some of the optional modules described inAppendix F provide additionalGIN operator classes.) Table 58-1. Built-inGIN Operator Classes 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.Name Indexed Data Type Indexable Operators _abstime_ops abstime[] &&<@=@> _bit_ops bit[] &&<@=@> _bool_ops boolean[] &&<@=@> _bpchar_ops character[] &&<@=@> _bytea_ops bytea[] &&<@=@> _char_ops "char"[] &&<@=@> _cidr_ops cidr[] &&<@=@> _date_ops date[] &&<@=@> _float4_ops float4[] &&<@=@> _float8_ops float8[] &&<@=@> _inet_ops inet[] &&<@=@> _int2_ops smallint[] &&<@=@> _int4_ops integer[] &&<@=@> _int8_ops bigint[] &&<@=@> _interval_ops interval[] &&<@=@> _macaddr_ops macaddr[] &&<@=@> _money_ops money[] &&<@=@> _name_ops name[] &&<@=@> _numeric_ops numeric[] &&<@=@> _oid_ops oid[] &&<@=@> _oidvector_ops oidvector[] &&<@=@> _reltime_ops reltime[] &&<@=@> _text_ops text[] &&<@=@> _time_ops time[] &&<@=@> _timestamp_ops timestamp[] &&<@=@> _timestamptz_ops timestamp with time zone[] &&<@=@> _timetz_ops time with time zone[] &&<@=@> _tinterval_ops tinterval[] &&<@=@> _varbit_ops bit varying[] &&<@=@> _varchar_ops character varying[] &&<@=@> jsonb_ops jsonb ??&?|@> jsonb_path_ops jsonb @> tsvector_ops tsvector @@@@@