SQL/JSON constructors
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.
JSON
Description
Adds SQL/JSON constructors, including JSON_ARRAY(), JSON_ARRAYAGG(), JSON_OBJECT(), and JSON_OBJECTAGG().
Selected version: PostgreSQL 18
Yes
Compare versions
Original documentation links
Recorded legacy identifiers: 395
Complete source facts and provenance
yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd
{
"Key": "sqljson-constructors",
"SourceKind": "yaml",
"SourceDatabase": "center",
"SourceTable": "featurematrix.yaml",
"SourceKey": "SQL/JSON constructors",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"Name": "SQL/JSON constructors",
"NameLocale": "en",
"GroupKey": "json",
"GroupName": "JSON",
"GroupLocale": "en",
"Ordinal": 5,
"GroupOrder": 6,
"Facts": {
"feature": {
"description": "Adds SQL/JSON constructors, including `JSON_ARRAY()`, `JSON_ARRAYAGG()`, `JSON_OBJECT()`, and `JSON_OBJECTAGG()`.",
"name": "SQL/JSON constructors",
"versions": {
"16": "Yes"
}
},
"group": "JSON",
"versions": {
"max": 18,
"min": 8.1
}
},
"Cells": [
{
"Version": "10",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "11",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "12",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "13",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "14",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "15",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "16",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "16",
"Supported": true,
"Original": "Yes"
},
{
"Version": "17",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "16",
"Supported": true,
"Original": "Yes"
},
{
"Version": "18",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "16",
"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": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.0",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.1",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.2",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.3",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.4",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.5",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.6",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
}
],
"Texts": [
{
"Locale": "en",
"Title": "SQL/JSON constructors",
"BodyHTML": "\u003cp\u003eAdds SQL/JSON constructors, including \u003ccode\u003eJSON_ARRAY()\u003c/code\u003e, \u003ccode\u003eJSON_ARRAYAGG()\u003c/code\u003e, \u003ccode\u003eJSON_OBJECT()\u003c/code\u003e, and \u003ccode\u003eJSON_OBJECTAGG()\u003c/code\u003e.\u003c/p\u003e\n",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"ContentHash": "4cd12556f30ef509eae7a3b0dd85febde376734dafc977d627ec7ee6eaccd9ae",
"Payload": {
"description": "Adds SQL/JSON constructors, including `JSON_ARRAY()`, `JSON_ARRAYAGG()`, `JSON_OBJECT()`, and `JSON_OBJECTAGG()`.",
"name": "SQL/JSON constructors",
"versions": {
"16": "Yes"
}
}
},
{
"Locale": "zh-Hans",
"Title": "SQL/JSON 构造函数",
"BodyHTML": "\u003cp\u003e新增 SQL/JSON 构造函数，包括 \u003ccode\u003eJSON_ARRAY()\u003c/code\u003e、\u003ccode\u003eJSON_ARRAYAGG()\u003c/code\u003e、\u003ccode\u003eJSON_OBJECT()\u003c/code\u003e 和 \u003ccode\u003eJSON_OBJECTAGG()\u003c/code\u003e。\u003c/p\u003e\n",
"SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
"ContentHash": "f632f50999a927d074f46149de1e852e7376a0f29e2023f3fb32cb5de4ea4dd8",
"Payload": {
"description": "新增 SQL/JSON 构造函数，包括 `JSON_ARRAY()`、`JSON_ARRAYAGG()`、`JSON_OBJECT()` 和 `JSON_OBJECTAGG()`。",
"name": "SQL/JSON 构造函数"
}
}
],
"GroupTitles": {
"en": "JSON",
"zh-Hans": "JSON"
},
"LegacyIDs": [
"395"
]
}