聚合函数的 FILTER 子句
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
聚合函数现在可以使用 FILTER 子句进行过滤。例如：count(col_a) FILTER (WHERE col_b > 5)
Selected version: PostgreSQL 18
No
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 · b355381ecb09d4ce4e6de9bd96e57eaad9288a10de33658a435f1c47ac229b98
{
"Key": "263",
"SourceKind": "legacy",
"SourceDatabase": "center",
"SourceTable": "featurematrix_feature",
"SourceKey": "263",
"SourceHash": "b355381ecb09d4ce4e6de9bd96e57eaad9288a10de33658a435f1c47ac229b98",
"Name": "聚合函数的 FILTER 子句",
"NameLocale": "zh-Hans",
"GroupKey": "10",
"GroupName": "自定义函数、存储过程和触发器",
"GroupLocale": "zh-Hans",
"Ordinal": 0,
"GroupOrder": 30,
"Facts": {
"featuredescription": "聚合函数现在可以使用 FILTER 子句进行过滤。例如：count(col_a) FILTER (WHERE col_b \u003e 5)",
"featurename": "聚合函数的 FILTER 子句",
"group_id": 10,
"id": 263,
"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": 0,
"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": "no",
"EvidenceKind": "legacy-database:v93",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"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": "聚合函数的 FILTER 子句",
"BodyHTML": "\u003cp\u003e聚合函数现在可以使用 FILTER 子句进行过滤。例如：count(col_a) FILTER (WHERE col_b \u0026gt; 5)\u003c/p\u003e\n",
"SourceHash": "b355381ecb09d4ce4e6de9bd96e57eaad9288a10de33658a435f1c47ac229b98",
"ContentHash": "eff47137968b2ad23c5f744c1cd5520bc7f7b4918ef931119f256a3bfafeb067",
"Payload": {
"description": "聚合函数现在可以使用 FILTER 子句进行过滤。例如：count(col_a) FILTER (WHERE col_b \u003e 5)",
"name": "聚合函数的 FILTER 子句"
}
}
],
"GroupTitles": {
"zh-Hans": "自定义函数、存储过程和触发器"
},
"RelatedKey": "filter-clause-for-aggregate-functions"
}