intagg
intagg
intagg : integer aggregator and enumerator (obsolete)
Overview
| ID | Extension | Package | Version | Category | License | Language |
|---|---|---|---|---|---|---|
| 4970 | intagg | intagg | 1.1 | FUNC | PostgreSQL | C |
| Attribute | Has Binary | Has Library | Need Load | Has DDL | Relocatable | Trusted |
|---|---|---|---|---|---|---|
----d-- | No | No | No | Yes | no | no |
| Relationships | |
|---|---|
| See Also | topn quantile lower_quantile count_distinct omnisketch ddsketch tdigest first_last_agg |
Packages
| PG18 | PG17 | PG16 | PG15 | PG14 |
|---|---|---|---|---|
1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
This is a built-in contrib extension ship with the PostgreSQL kernel
Install
Create this extension with:
CREATE EXTENSION intagg;Usage
Provides an integer aggregator and enumerator. These are now wrappers around the built-in array_agg() and unnest() functions.
CREATE EXTENSION intagg;Functions
| Function | Description |
|---|---|
int_array_aggregate(integer) | Aggregate integers into an array (wrapper for array_agg()) |
int_array_enum(integer[]) | Expand array into rows (wrapper for unnest()) |
Examples
-- Aggregate integers into an array
SELECT id_left, int_array_aggregate(id_right) AS rights
FROM many_to_many
GROUP BY id_left;
-- Expand an integer array into rows
SELECT int_array_enum(ARRAY[1, 2, 3, 4]);
-- Returns: 1, 2, 3, 4 (as separate rows)Note: This module is obsolete. Use the built-in array_agg() and unnest() functions instead for new code.
Last updated on