Examples
PostgreSQL 9.4.26 Documentation | |||
---|---|---|---|
Prev | Up | Chapter 58. 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