intagg

integer aggregator and enumerator (obsolete)

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	intarray count_distinct arraymath

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

intagg: integer aggregator and enumerator (obsolete)

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.