WITH 查询 (公用表表达式)
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.
The source label is retained in Chinese; no translated label is recorded.
No prose description is recorded; original links and version facts remain available.
SQL
Description
Selected version: PostgreSQL 18
No
Compare versions
Original documentation links
Complete source facts and provenance
legacy · center · abc7ebae4735226089f0bdf2579d855a08d467cf46b8dab591488781da84cb2d
{
"Key": "132",
"SourceKind": "legacy",
"SourceDatabase": "center",
"SourceTable": "featurematrix_feature",
"SourceKey": "132",
"SourceHash": "abc7ebae4735226089f0bdf2579d855a08d467cf46b8dab591488781da84cb2d",
"Name": "WITH 查询 (公用表表达式)",
"NameLocale": "zh-Hans",
"GroupKey": "15",
"GroupName": "SQL",
"GroupLocale": "en",
"Ordinal": 0,
"GroupOrder": 6,
"Facts": {
"featuredescription": "https://www.postgresql.org/docs/current/queries-with.html",
"featurename": "WITH 查询 (公用表表达式)",
"group_id": 15,
"id": 132,
"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": "",
"BodyHTML": "\u003cp\u003ehttps://www.postgresql.org/docs/current/queries-with.html\u003c/p\u003e\n",
"SourceHash": "abc7ebae4735226089f0bdf2579d855a08d467cf46b8dab591488781da84cb2d",
"ContentHash": "b61eec2233075094da497140d5337e1984b2028238904be174429c24be0c4c20",
"Payload": {
"description": "https://www.postgresql.org/docs/current/queries-with.html"
}
},
{
"Locale": "zh-Hans",
"Title": "WITH 查询 (公用表表达式)",
"BodyHTML": "",
"SourceHash": "abc7ebae4735226089f0bdf2579d855a08d467cf46b8dab591488781da84cb2d",
"ContentHash": "1a3060b0234230fdcd24d6d01eb9add83fcec79dbe5a91f4869c2149fc2e41e5",
"Payload": {
"name": "WITH 查询 (公用表表达式)"
}
}
],
"GroupTitles": {
"en": "SQL"
}
}