On this page
63.7. Examples
The PostgreSQL source distribution includes GIN operator classes for tsvector and for one-dimensional arrays of all internal types. Prefix searching in tsvector is implemented using the GIN partial match feature. The following contrib modules also contain GIN operator classes:
-
btree_gin -
B-tree equivalent functionality for several data types
-
hstore -
Module for storing (key, value) pairs
-
intarray -
Enhanced support for
int[] -
pg_trgm -
Text similarity using trigram matching
© 1996–2019 The PostgreSQL Global Development Group
Licensed under the PostgreSQL License.
https://www.postgresql.org/docs/9.6/gin-examples.html