↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / Versions

改进的 JSON 函数和运算符集

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. The source label is retained in Chinese; no translated label is recorded.

数据类型、函数和运算符

Description

新增了从 JSON 数据字符串中提取值的运算符和函数,JSON 数据字符串现在可以转换为记录,并新增了将值、记录和 hstore 数据转换为 JSON 的函数。

Selected version: PostgreSQL 18

No

20191817161514131211109.69.59.49.39.29.19.08.48.38.28.18.07.4
UnknownUnknownNoNoNoNoNoYesYesYesYesYesYesYesYesNoNoNoNoNoNoNoNoNo

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 · 43046c81fef1dd7cb30a29e1df21ae512be4b0d9cf06034bca98ff387d49dd52

{
  "Key": "249",
  "SourceKind": "legacy",
  "SourceDatabase": "center",
  "SourceTable": "featurematrix_feature",
  "SourceKey": "249",
  "SourceHash": "43046c81fef1dd7cb30a29e1df21ae512be4b0d9cf06034bca98ff387d49dd52",
  "Name": "改进的 JSON 函数和运算符集",
  "NameLocale": "zh-Hans",
  "GroupKey": "9",
  "GroupName": "数据类型、函数和运算符",
  "GroupLocale": "zh-Hans",
  "Ordinal": 0,
  "GroupOrder": 2,
  "Facts": {
    "featuredescription": "新增了从 JSON 数据字符串中提取值的运算符和函数,JSON 数据字符串现在可以转换为记录,并新增了将值、记录和 hstore 数据转换为 JSON 的函数。",
    "featurename": "改进的 JSON 函数和运算符集",
    "group_id": 9,
    "id": 249,
    "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": 0,
    "v90": 0,
    "v91": 0,
    "v92": 0,
    "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": "no",
      "EvidenceKind": "legacy-database:v84",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "9.0",
      "State": "no",
      "EvidenceKind": "legacy-database:v90",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "9.1",
      "State": "no",
      "EvidenceKind": "legacy-database:v91",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "Version": "9.2",
      "State": "no",
      "EvidenceKind": "legacy-database:v92",
      "TransitionVersion": "",
      "Supported": false,
      "Original": 0
    },
    {
      "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": "zh-Hans",
      "Title": "改进的 JSON 函数和运算符集",
      "BodyHTML": "\u003cp\u003e新增了从 JSON 数据字符串中提取值的运算符和函数,JSON 数据字符串现在可以转换为记录,并新增了将值、记录和 hstore 数据转换为 JSON 的函数。\u003c/p\u003e\n",
      "SourceHash": "43046c81fef1dd7cb30a29e1df21ae512be4b0d9cf06034bca98ff387d49dd52",
      "ContentHash": "fb0c2d46943baca980d213b3f46d2b3bbc579afd83e7309d5f8050fe157e1f6c",
      "Payload": {
        "description": "新增了从 JSON 数据字符串中提取值的运算符和函数,JSON 数据字符串现在可以转换为记录,并新增了将值、记录和 hstore 数据转换为 JSON 的函数。",
        "name": "改进的 JSON 函数和运算符集"
      }
    }
  ],
  "GroupTitles": {
    "zh-Hans": "数据类型、函数和运算符"
  },
  "RelatedKey": "improved-set-of-json-functions-and-operators"
}

Complete source data JSON