Examples
| PostgreSQL 9.6.24 Documentation | |||
|---|---|---|---|
| Prev | Up | Chapter 63. GIN Indexes | Next |
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