{"capability":{"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"]},"observed":true,"selected_cell":{"Version":"18","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"8.4","Supported":true,"Original":"Yes"},"selected_version":"18"}