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