↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Versions

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.

No translation of this description is recorded. The original Chinese description is shown.

后端

Description

unnest 允许将数组"展开"并扩展为一组行。

相反,array_agg 可以将一组行的输出聚合为一个数组。

更多信息:

Selected version: PostgreSQL 18

No

20191817161514131211109.69.59.49.39.29.19.08.48.38.28.18.07.4
UnknownUnknownNoNoNoNoNoYesYesYesYesYesYesYesYesYesYesYesYesNoNoNoNoNo

Compare versions

Original documentation links

Related source snapshot entry · The original source supplies this relationship; each matrix retains its own states.

Complete source facts and provenance

legacy · center · a96f8d342a7714fed1234698d82ae76a908356ccae92f6ab5c894beed28713e8

{
  "Key": "139",
  "SourceKind": "legacy",
  "SourceDatabase": "center",
  "SourceTable": "featurematrix_feature",
  "SourceKey": "139",
  "SourceHash": "a96f8d342a7714fed1234698d82ae76a908356ccae92f6ab5c894beed28713e8",
  "Name": "unnest/array_agg",
  "NameLocale": "en",
  "GroupKey": "4",
  "GroupName": "后端",
  "GroupLocale": "zh-Hans",
  "Ordinal": 0,
  "GroupOrder": 0,
  "Facts": {
    "featuredescription": "`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)",
    "featurename": "unnest/array_agg",
    "group_id": 4,
    "id": 139,
    "v10": 1,
    "v11": 1,
    "v12": 1,
    "v13": 1,
    "v14": 0,
    "v15": 0,
    "v16": 0,
    "v17": 0,
    "v18": 0,
    "v74": 0,
    "v80": 0,
    "v81": 0,
    "v82": 0,
    "v83": 0,
    "v84": 1,
    "v90": 1,
    "v91": 1,
    "v92": 1,
    "v93": 1,
    "v94": 1,
    "v95": 1,
    "v96": 1
  },
  "Cells": [
    {
      "Version": "10",
      "State": "yes",
      "EvidenceKind": "legacy-database:v10",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "11",
      "State": "yes",
      "EvidenceKind": "legacy-database:v11",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "12",
      "State": "yes",
      "EvidenceKind": "legacy-database:v12",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "13",
      "State": "yes",
      "EvidenceKind": "legacy-database:v13",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "14",
      "State": "no",
      "EvidenceKind": "legacy-database:v14",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "15",
      "State": "no",
      "EvidenceKind": "legacy-database:v15",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "16",
      "State": "no",
      "EvidenceKind": "legacy-database:v16",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "17",
      "State": "no",
      "EvidenceKind": "legacy-database:v17",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "18",
      "State": "no",
      "EvidenceKind": "legacy-database:v18",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "7.4",
      "State": "no",
      "EvidenceKind": "legacy-database:v74",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "8.0",
      "State": "no",
      "EvidenceKind": "legacy-database:v80",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "8.1",
      "State": "no",
      "EvidenceKind": "legacy-database:v81",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "8.2",
      "State": "no",
      "EvidenceKind": "legacy-database:v82",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "8.3",
      "State": "no",
      "EvidenceKind": "legacy-database:v83",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "8.4",
      "State": "yes",
      "EvidenceKind": "legacy-database:v84",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "9.0",
      "State": "yes",
      "EvidenceKind": "legacy-database:v90",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "9.1",
      "State": "yes",
      "EvidenceKind": "legacy-database:v91",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "9.2",
      "State": "yes",
      "EvidenceKind": "legacy-database:v92",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "9.3",
      "State": "yes",
      "EvidenceKind": "legacy-database:v93",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "9.4",
      "State": "yes",
      "EvidenceKind": "legacy-database:v94",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "9.5",
      "State": "yes",
      "EvidenceKind": "legacy-database:v95",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    },
    {
      "Version": "9.6",
      "State": "yes",
      "EvidenceKind": "legacy-database:v96",
      "TransitionVersion": "",
      "Supported": true,
      "Original": 1
    }
  ],
  "Texts": [
    {
      "Locale": "en",
      "Title": "unnest/array_agg",
      "BodyHTML": "",
      "SourceHash": "a96f8d342a7714fed1234698d82ae76a908356ccae92f6ab5c894beed28713e8",
      "ContentHash": "41ac51e8aa81c9b507850c466f87577b653e5ff411edf1c473c7c84647ba4418",
      "Payload": {
        "name": "unnest/array_agg"
      }
    },
    {
      "Locale": "zh-Hans",
      "Title": "",
      "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": "a96f8d342a7714fed1234698d82ae76a908356ccae92f6ab5c894beed28713e8",
      "ContentHash": "b69579eebab06ec8ef18539f976eee9c5bc4d8b7779a26ffa7a66b33a6c9cc5a",
      "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)"
      }
    }
  ],
  "GroupTitles": {
    "zh-Hans": "后端"
  },
  "RelatedKey": "unnestarray_agg"
}

Complete source data JSON