Aggregates Aggregate

bitstring_agg()

Returns a bitstring with bits set for each distinct value.

Arguments & returns

20 overloads

Aggregate

Aggregate

Overload link	`arg`	`col1`	`col2`	Returns
#11	`BIGINT`	`BIGINT`	`BIGINT`	`BIT`
#12	`HUGEINT`	`HUGEINT`	`HUGEINT`	`BIT`
#13	`INTEGER`	`INTEGER`	`INTEGER`	`BIT`
#14	`SMALLINT`	`SMALLINT`	`SMALLINT`	`BIT`
#15	`TINYINT`	`TINYINT`	`TINYINT`	`BIT`
#16	`UBIGINT`	`UBIGINT`	`UBIGINT`	`BIT`
#17	`UHUGEINT`	`UHUGEINT`	`UHUGEINT`	`BIT`
#18	`UINTEGER`	`UINTEGER`	`UINTEGER`	`BIT`
#19	`USMALLINT`	`USMALLINT`	`USMALLINT`	`BIT`
#20	`UTINYINT`	`UTINYINT`	`UTINYINT`	`BIT`

SELECT bitstring_agg(value, 1, 5) AS present
FROM (VALUES (1), (3), (5)) AS data(value);

Haybarn WASM 1.5.5-rc3 · In your browser

Guide example · Run to view results.

SELECT
  bitstring_agg(A);