unnest/array_agg
Recorded source states and original language descriptions. Missing version evidence stays unknown.
The source snapshot records transitions for PostgreSQL 8.1–18. The historical matrix records independent cells for 7.4–18. Neither records support for PostgreSQL 19 or 20; newer versions remain unknown. These source claims are distinct from runtime measurements.
SQL
Description
unnest allows for arrays to be "unnested" and expanded into a set of rows.
Conversely, array_agg can take the output of a set of rows and aggregate them into an array.
For more information:
Selected version: PostgreSQL 18
Yes
Compare versions
Original documentation links
Recorded legacy identifiers: 139
Complete source facts and provenance
yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd
{
"Key": "unnestarray_agg",
"SourceKind": "yaml",
"SourceDatabase": "center",
"SourceTable": "featurematrix.yaml",
"SourceKey": "unnest/array_agg",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"Name": "unnest/array_agg",
"NameLocale": "en",
"GroupKey": "sql",
"GroupName": "SQL",
"GroupLocale": "en",
"Ordinal": 20,
"GroupOrder": 3,
"Facts": {
"feature": {
"description": "`unnest` allows for arrays to be \"unnested\" and expanded into a set of rows.\r\n\r\nConversely, `array_agg` can take the output of a set of rows and aggregate them into an array.\r\n\r\nFor more information:\r\n\r\n- [Array Functions](https://www.postgresql.org/docs/current/functions-array.html)\r\n- [Aggregation Functions](https://www.postgresql.org/docs/current/functions-aggregate.html)",
"name": "unnest/array_agg",
"versions": {
"8.4": "Yes"
}
},
"group": "SQL",
"versions": {
"max": 18,
"min": 8.1
}
},
"Cells": [
{
"Version": "10",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "11",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "12",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "13",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "14",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "15",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "16",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "17",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "18",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "8.1",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "8.2",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "8.3",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "8.4",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.0",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.1",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.2",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.3",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.4",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.5",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.6",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "8.4",
"Supported": true,
"Original": "Yes"
}
],
"Texts": [
{
"Locale": "en",
"Title": "unnest/array_agg",
"BodyHTML": "\u003cp\u003e\u003ccode\u003eunnest\u003c/code\u003e allows for arrays to be \u0026#34;unnested\u0026#34; and expanded into a set of rows.\u003c/p\u003e\n\u003cp\u003eConversely, \u003ccode\u003earray_agg\u003c/code\u003e can take the output of a set of rows and aggregate them into an array.\u003c/p\u003e\n\u003cp\u003eFor more information:\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003e\u003ca href=\"https://www.postgresql.org/docs/current/functions-array.html\" rel=\"nofollow\"\u003eArray Functions\u003c/a\u003e\u003c/li\u003e\n\u003cli\u003e\u003ca href=\"https://www.postgresql.org/docs/current/functions-aggregate.html\" rel=\"nofollow\"\u003eAggregation Functions\u003c/a\u003e\u003c/li\u003e\n\u003c/ul\u003e\n",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"ContentHash": "e4290d1a10387ed9c6f885eac4d1bbe592200c5f6671783bb28952d9a7024610",
"Payload": {
"description": "`unnest` allows for arrays to be \"unnested\" and expanded into a set of rows.\r\n\r\nConversely, `array_agg` can take the output of a set of rows and aggregate them into an array.\r\n\r\nFor more information:\r\n\r\n- [Array Functions](https://www.postgresql.org/docs/current/functions-array.html)\r\n- [Aggregation Functions](https://www.postgresql.org/docs/current/functions-aggregate.html)",
"name": "unnest/array_agg",
"versions": {
"8.4": "Yes"
}
}
},
{
"Locale": "zh-Hans",
"Title": "unnest/array_agg",
"BodyHTML": "\u003cp\u003e\u003ccode\u003eunnest\u003c/code\u003e 允许将数组\u0026#34;展开\u0026#34;并扩展为一组行。\u003c/p\u003e\n\u003cp\u003e相反，\u003ccode\u003earray_agg\u003c/code\u003e 可以将一组行的输出聚合为一个数组。\u003c/p\u003e\n\u003cp\u003e更多信息：\u003c/p\u003e\n\u003cul\u003e\n\u003cli\u003e\u003ca href=\"https://www.postgresql.org/docs/current/functions-array.html\" rel=\"nofollow\"\u003e数组函数\u003c/a\u003e\u003c/li\u003e\n\u003cli\u003e\u003ca href=\"https://www.postgresql.org/docs/current/functions-aggregate.html\" rel=\"nofollow\"\u003e聚合函数\u003c/a\u003e\u003c/li\u003e\n\u003c/ul\u003e\n",
"SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
"ContentHash": "8f2b493f07fa3f31f9aefbc4aaf0989bd16a86ccdd7446b9dd13319921a40c32",
"Payload": {
"description": "`unnest` 允许将数组\"展开\"并扩展为一组行。\n\n相反，`array_agg` 可以将一组行的输出聚合为一个数组。\n\n更多信息：\n\n- [数组函数](https://www.postgresql.org/docs/current/functions-array.html)\n- [聚合函数](https://www.postgresql.org/docs/current/functions-aggregate.html)",
"name": "unnest/array_agg"
}
}
],
"GroupTitles": {
"en": "SQL",
"zh-Hans": "SQL"
},
"LegacyIDs": [
"139"
]
}