Postgresql 中文操作指南

70.7. Examples #

PostgreSQL 核心发行版包括之前在 Table 70.1中展示的 GIN 运算符类。以下 _contrib_模块还包含 GIN 运算符类：

The core PostgreSQL distribution includes the GIN operator classes previously shown in Table 70.1. 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