Search PostgreSQL documentation

btree/tid_ops (family)Operator FamiliesWikiOperator Families · B-tree familiesB-tree operator family containing 1 classes, 5 operator strategies and 2 support functions in this source build. B-tree families B-tree operator family containing 1 classes, 5 operator stra… btree/time_ops (class)Operator FamiliesWikiOperator Families · B-tree classesB-tree operator class for time; member of time_ops. B-tree classes btree/time_ops Object kind Operator class Index AM B-tree Input type time Stored key type Same as input type (catalog zero… btree/time_ops (family)Operator FamiliesWikiOperator Families · B-tree familiesB-tree operator family containing 1 classes, 5 operator strategies and 3 support functions in this source build. B-tree families B-tree operator family containing 1 classes, 5 operator stra… btree/timestamp_ops (class)Operator FamiliesWikiOperator Families · B-tree classesB-tree operator class for timestamp; member of datetime_ops. B-tree classes btree/timestamp_ops Object kind Operator class Index AM B-tree Input type timestamp Stored key type Same as input… btree/timestamptz_ops (class)Operator FamiliesWikiOperator Families · B-tree classesB-tree operator class for timestamptz; member of datetime_ops. B-tree classes btree/timestamptz_ops Object kind Operator class Index AM B-tree Input type timestamptz Stored key type Same as… btree/timetz_ops (class)Operator FamiliesWikiOperator Families · B-tree classesB-tree operator class for timetz; member of timetz_ops. B-tree classes btree/timetz_ops Object kind Operator class Index AM B-tree Input type timetz Stored key type Same as input type (cata… btree/timetz_ops (family)Operator FamiliesWikiOperator Families · B-tree familiesB-tree operator family containing 1 classes, 5 operator strategies and 3 support functions in this source build. B-tree families B-tree operator family containing 1 classes, 5 operator stra… btree/tinterval_ops (class)Operator FamiliesWikiOperator Families · B-tree classesB-tree operator class for tinterval; member of tinterval_ops. B-tree classes btree/tinterval_ops Object kind Operator class Index AM B-tree Input type tinterval Stored key type Same as inpu… btree/tinterval_ops (family)Operator FamiliesWikiOperator Families · B-tree familiesB-tree operator family containing 1 classes, 5 operator strategies and 1 support functions in this source build. B-tree families btree/tinterval_ops Object kind Operator family Index AM B-t… btree/tsquery_ops (class)Operator FamiliesWikiOperator Families · B-tree classesB-tree operator class for tsquery; member of tsquery_ops. B-tree classes btree/tsquery_ops Object kind Operator class Index AM B-tree Input type tsquery Stored key type Same as input type (… btree/tsquery_ops (family)Operator FamiliesWikiOperator Families · B-tree familiesB-tree operator family containing 1 classes, 5 operator strategies and 1 support functions in this source build. B-tree families btree/tsquery_ops Object kind Operator family Index AM B-tre… btree/tsvector_ops (class)Operator FamiliesWikiOperator Families · B-tree classesB-tree operator class for tsvector; member of tsvector_ops. B-tree classes btree/tsvector_ops Object kind Operator class Index AM B-tree Input type tsvector Stored key type Same as input ty… btree/tsvector_ops (family)Operator FamiliesWikiOperator Families · B-tree familiesB-tree operator family containing 1 classes, 5 operator strategies and 1 support functions in this source build. B-tree families btree/tsvector_ops Object kind Operator family Index AM B-tr… btree/uuid_ops (class)Operator FamiliesWikiOperator Families · B-tree classesB-tree operator class for uuid; member of uuid_ops. B-tree classes btree/uuid_ops Object kind Operator class Index AM B-tree Input type uuid Stored key type Same as input type (catalog zero… btree/uuid_ops (family)Operator FamiliesWikiOperator Families · B-tree familiesB-tree operator family containing 1 classes, 5 operator strategies and 4 support functions in this source build. B-tree families B-tree operator family containing 1 classes, 5 operator stra… btree/varbit_ops (class)Operator FamiliesWikiOperator Families · B-tree classesB-tree operator class for varbit; member of varbit_ops. B-tree classes btree/varbit_ops Object kind Operator class Index AM B-tree Input type varbit Stored key type Same as input type (cata… btree/varbit_ops (family)Operator FamiliesWikiOperator Families · B-tree familiesB-tree operator family containing 1 classes, 5 operator strategies and 2 support functions in this source build. B-tree families B-tree operator family containing 1 classes, 5 operator stra… btree/varchar_ops (class)Operator FamiliesWikiOperator Families · B-tree classesB-tree operator class for text; member of text_ops. B-tree classes btree/varchar_ops Object kind Operator class Index AM B-tree Input type text Stored key type Same as input type (catalog z… btree/varchar_pattern_ops (class)Operator FamiliesWikiOperator Families · B-tree classesB-tree operator class for text; member of text_pattern_ops. B-tree classes btree/varchar_pattern_ops Object kind Operator class Index AM B-tree Input type text Stored key type Same as input… btree/xid8_ops (class)Operator FamiliesWikiOperator Families · B-tree classesB-tree operator class for xid8; member of xid8_ops. B-tree classes btree/xid8_ops Object kind Operator class Index AM B-tree Input type xid8 Stored key type Same as input type (catalog zero… btree/xid8_ops (family)Operator FamiliesWikiOperator Families · B-tree familiesB-tree operator family containing 1 classes, 5 operator strategies and 2 support functions in this source build. B-tree families btree/xid8_ops Object kind Operator family Index AM B-tree O… gin/array_ops (class)Operator FamiliesWikiOperator Families · GIN classesGIN operator class for anyarray; member of array_ops. GIN classes gin/array_ops Object kind Operator class Index AM GIN Input type anyarray Stored key type anyelement Default class yes Oper… gin/array_ops (family)Operator FamiliesWikiOperator Families · GIN familiesGIN operator family containing 1 classes, 4 operator strategies and 4 support functions in this source build. GIN families gin/array_ops Object kind Operator family Index AM GIN Operator cl… gin/jsonb_ops (class)Operator FamiliesWikiOperator Families · GIN classesGIN operator class for jsonb; member of jsonb_ops. GIN classes gin/jsonb_ops Object kind Operator class Index AM GIN Input type jsonb Stored key type text Default class yes Operator classes… gin/jsonb_ops (family)Operator FamiliesWikiOperator Families · GIN familiesGIN operator family containing 1 classes, 6 operator strategies and 5 support functions in this source build. GIN families GIN operator family containing 1 classes, 4 operator strategies an… gin/jsonb_path_ops (class)Operator FamiliesWikiOperator Families · GIN classesGIN operator class for jsonb; member of jsonb_path_ops. GIN classes gin/jsonb_path_ops Object kind Operator class Index AM GIN Input type jsonb Stored key type int4 Default class no Operato… gin/jsonb_path_ops (family)Operator FamiliesWikiOperator Families · GIN familiesGIN operator family containing 1 classes, 3 operator strategies and 5 support functions in this source build. GIN families GIN operator family containing 1 classes, 1 operator strategies an… gin/tsvector_ops (class)Operator FamiliesWikiOperator Families · GIN classesGIN operator class for tsvector; member of tsvector_ops. GIN classes gin/tsvector_ops Object kind Operator class Index AM GIN Input type tsvector Stored key type text Default class yes Oper… gin/tsvector_ops (family)Operator FamiliesWikiOperator Families · GIN familiesGIN operator family containing 1 classes, 2 operator strategies and 6 support functions in this source build. GIN families gin/tsvector_ops Object kind Operator family Index AM GIN Operator… gist/box_ops (class)Operator FamiliesWikiOperator Families · GiST classesGiST operator class for box; member of box_ops. GiST classes gist/box_ops Object kind Operator class Index AM GiST Input type box Stored key type Same as input type (catalog zero) Default c… gist/box_ops (family)Operator FamiliesWikiOperator Families · GiST familiesGiST operator family containing 1 classes, 13 operator strategies and 7 support functions in this source build. GiST families GiST operator family containing 1 classes, 14 operator strategi… gist/circle_ops (class)Operator FamiliesWikiOperator Families · GiST classesGiST operator class for circle; member of circle_ops. GiST classes gist/circle_ops Object kind Operator class Index AM GiST Input type circle Stored key type box Default class yes Operator … gist/circle_ops (family)Operator FamiliesWikiOperator Families · GiST familiesGiST operator family containing 1 classes, 13 operator strategies and 8 support functions in this source build. GiST families GiST operator family containing 1 classes, 15 operator strategi… gist/inet_ops (class)Operator FamiliesWikiOperator Families · GiST classesGiST operator class for inet; member of network_ops. GiST classes gist/inet_ops Object kind Operator class Index AM GiST Input type inet Stored key type Same as input type (catalog zero) De… gist/jsonb_ops (family)Operator FamiliesWikiOperator Families · GiST familiesGiST operator family containing 0 classes, 0 operator strategies and 0 support functions in this source build. GiST families gist/jsonb_ops Object kind Operator family Index AM GiST Operato… gist/multirange_ops (class)Operator FamiliesWikiOperator Families · GiST classesGiST operator class for anymultirange; member of multirange_ops. GiST classes gist/multirange_ops Object kind Operator class Index AM GiST Input type anymultirange Stored key type anyrange … gist/multirange_ops (family)Operator FamiliesWikiOperator Families · GiST familiesGiST operator family containing 1 classes, 18 operator strategies and 7 support functions in this source build. GiST families GiST operator family containing 1 classes, 18 operator strategi… gist/network_ops (family)Operator FamiliesWikiOperator Families · GiST familiesGiST operator family containing 1 classes, 11 operator strategies and 8 support functions in this source build. GiST families gist/network_ops Object kind Operator family Index AM GiST Oper… gist/point_ops (class)Operator FamiliesWikiOperator Families · GiST classesGiST operator class for point; member of point_ops. GiST classes gist/point_ops Object kind Operator class Index AM GiST Input type point Stored key type box Default class yes Operator clas… gist/point_ops (family)Operator FamiliesWikiOperator Families · GiST familiesGiST operator family containing 1 classes, 11 operator strategies and 9 support functions in this source build. GiST families GiST operator family containing 1 classes, 9 operator strategie…