select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Functions and aggregates

parray_gin

GIN index operator class and partial-match operators for text arrays

pgext.cloud · Source code · License text · Control file · PGXN

Overview

Packageparray_gin
Version1.5.0
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPIGSTY
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars24
Latest commit2026-05-25
Latest release2026-04-19
Catalogue updated2026-08-30

Related extensions

See also

intarrayfunctions, operators, and index support for 1-D arrays of integers
btree_ginsupport for indexing common datatypes in GIN
btree_gistsupport for indexing common datatypes in GiST
rumRUM index access method
bloombloom access method - signature file based index
ora_btree_ginSupport for indexing oracle datatypes in GIN
orafceFunctions and operators that emulate a subset of functions and packages from the Oracle RDBMS
arraymathArray math and operators that work element by element on the contents of arrays
hlltype for storing hyperloglog data
roaringbitmapsupport for Roaring Bitmaps