Documentation → PostgreSQL 8.4

Supported Versions: 16 / 15 / 14 / 13 / 12

Unsupported versions: 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2

This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

PostgreSQL 8.4.22 Documentation
Prev	Fast Backward	Chapter 52. GIN Indexes	Fast Forward	Next

52.6. 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 int4[]
pg_trgm: Text similarity using trigram matching

Prev	Home	Next
Limitations	Up	Database Physical Storage