改进的 JSON 函数和操作符集
已记录的来源状态与原始语言说明；缺少版本证据时明确标为未知。
来源快照记录 PostgreSQL 8.1–18 的变化节点；历史矩阵独立记录 7.4–18 的状态。两者均未记录 PostgreSQL 19 或 20 的支持状态，较新版本明确保留为未知。这些来源声明与运行测量相互独立。
JSON
说明
新增了从 JSON 数据字符串中提取值的操作符和函数，JSON 数据字符串现在可以转换为记录，并新增了将值、记录和 hstore 数据转换为 JSON 的函数。
所选版本: PostgreSQL 18
支持
比较版本
原始文档链接
已记录旧标识: 249
完整来源事实与出处
yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd
{
"Key": "improved-set-of-json-functions-and-operators",
"SourceKind": "yaml",
"SourceDatabase": "center",
"SourceTable": "featurematrix.yaml",
"SourceKey": "Improved set of JSON functions and operators",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"Name": "Improved set of JSON functions and operators",
"NameLocale": "en",
"GroupKey": "json",
"GroupName": "JSON",
"GroupLocale": "en",
"Ordinal": 0,
"GroupOrder": 6,
"Facts": {
"feature": {
"description": "New operators and functions to extract values from JSON data strings, JSON data strings can now to be converted into records and new functions to convert values, records, and hstore data to JSON.",
"name": "Improved set of JSON functions and operators",
"versions": {
"9.3": "Yes"
}
},
"group": "JSON",
"versions": {
"max": 18,
"min": 8.1
}
},
"Cells": [
{
"Version": "10",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.3",
"Supported": true,
"Original": "Yes"
},
{
"Version": "11",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.3",
"Supported": true,
"Original": "Yes"
},
{
"Version": "12",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.3",
"Supported": true,
"Original": "Yes"
},
{
"Version": "13",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.3",
"Supported": true,
"Original": "Yes"
},
{
"Version": "14",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.3",
"Supported": true,
"Original": "Yes"
},
{
"Version": "15",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.3",
"Supported": true,
"Original": "Yes"
},
{
"Version": "16",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.3",
"Supported": true,
"Original": "Yes"
},
{
"Version": "17",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.3",
"Supported": true,
"Original": "Yes"
},
{
"Version": "18",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.3",
"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": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.3",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.4",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.3",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.5",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.3",
"Supported": true,
"Original": "Yes"
},
{
"Version": "9.6",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "9.3",
"Supported": true,
"Original": "Yes"
}
],
"Texts": [
{
"Locale": "en",
"Title": "Improved set of JSON functions and operators",
"BodyHTML": "\u003cp\u003eNew operators and functions to extract values from JSON data strings, JSON data strings can now to be converted into records and new functions to convert values, records, and hstore data to JSON.\u003c/p\u003e\n",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"ContentHash": "7e1c9e3bdbd8d2610029c9960457504102faece757fa2729514aa71941927103",
"Payload": {
"description": "New operators and functions to extract values from JSON data strings, JSON data strings can now to be converted into records and new functions to convert values, records, and hstore data to JSON.",
"name": "Improved set of JSON functions and operators",
"versions": {
"9.3": "Yes"
}
}
},
{
"Locale": "zh-Hans",
"Title": "改进的 JSON 函数和操作符集",
"BodyHTML": "\u003cp\u003e新增了从 JSON 数据字符串中提取值的操作符和函数，JSON 数据字符串现在可以转换为记录，并新增了将值、记录和 hstore 数据转换为 JSON 的函数。\u003c/p\u003e\n",
"SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
"ContentHash": "7e9691efa27c6eaadcc65a15e7002c203a4917e2907c0ff1a0f8b6e165327b33",
"Payload": {
"description": "新增了从 JSON 数据字符串中提取值的操作符和函数，JSON 数据字符串现在可以转换为记录，并新增了将值、记录和 hstore 数据转换为 JSON 的函数。",
"name": "改进的 JSON 函数和操作符集"
}
}
],
"GroupTitles": {
"en": "JSON",
"zh-Hans": "JSON"
},
"LegacyIDs": [
"249"
]
}