Extensions / Functions and aggregates
functions, operators, and index support for 1-D arrays of integers
pgext.cloud · Website · Documentation · License text · Control file
| Package | intarray |
|---|---|
| Version | 1.5 |
| PostgreSQL versions | 14 · 15 · 16 · 17 · 18 |
| Repository | PostgreSQL contrib |
| Extension type | SQL only |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | Yes |
| Latest commit | 2026-05-14 |
| Latest release | 2026-05-14 |
| Catalogue updated | 2026-07-29 |
| rtosm | Real-time simplification of spatial objects in an OpenStreetMap API database. |
| arraymath | Array math and operators that work element by element on the contents of arrays |
| floatvec | Math for vectors (arrays) of numbers |
| aggs_for_vecs | Aggregate functions for array inputs |
| aggs_for_arrays | Various functions for computing statistics on arrays of numbers |
| collection | Associative-array data types for high-performance PL/pgSQL workflows |
| hstore | data type for storing sets of (key, value) pairs |
| pgbson | BSON data type and accessor functions for PostgreSQL |
| parray_gin | GIN index operator class and partial-match operators for text arrays |
| btree_gin | support for indexing common datatypes in GIN |
| btree_gist | support for indexing common datatypes in GiST |