Upsert (INSERT ... ON CONFLICT DO ...)
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.
SQL
Description
支持 upsert 功能，当遇到冲突时可以选择不执行任何操作，或将 INSERT 转换为 UPDATE。
更多信息请参阅 INSERT 文档。
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 · 8b236e31c24755fe99eb3c625a54e3637e330fe128877959f8e9d54f2b3844cc
{
"Key": "275",
"SourceKind": "legacy",
"SourceDatabase": "center",
"SourceTable": "featurematrix_feature",
"SourceKey": "275",
"SourceHash": "8b236e31c24755fe99eb3c625a54e3637e330fe128877959f8e9d54f2b3844cc",
"Name": "Upsert (INSERT ... ON CONFLICT DO ...)",
"NameLocale": "en",
"GroupKey": "15",
"GroupName": "SQL",
"GroupLocale": "en",
"Ordinal": 0,
"GroupOrder": 6,
"Facts": {
"featuredescription": "支持 upsert 功能，当遇到冲突时可以选择不执行任何操作，或将 INSERT 转换为 UPDATE。\n\n更多信息请参阅 [INSERT](https://www.postgresql.org/docs/current/sql-insert.html) 文档。",
"featurename": "Upsert (INSERT ... ON CONFLICT DO ...)",
"group_id": 15,
"id": 275,
"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": 0,
"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": "no",
"EvidenceKind": "legacy-database:v94",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"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": "Upsert (INSERT ... ON CONFLICT DO ...)",
"BodyHTML": "",
"SourceHash": "8b236e31c24755fe99eb3c625a54e3637e330fe128877959f8e9d54f2b3844cc",
"ContentHash": "7e5d4256230de183db3e9d32300e8c699e2e8ba3c5daf5a9d7f3cabcee97e3a9",
"Payload": {
"name": "Upsert (INSERT ... ON CONFLICT DO ...)"
}
},
{
"Locale": "zh-Hans",
"Title": "",
"BodyHTML": "\u003cp\u003e支持 upsert 功能，当遇到冲突时可以选择不执行任何操作，或将 INSERT 转换为 UPDATE。\u003c/p\u003e\n\u003cp\u003e更多信息请参阅 \u003ca href=\"https://www.postgresql.org/docs/current/sql-insert.html\" rel=\"nofollow\"\u003eINSERT\u003c/a\u003e 文档。\u003c/p\u003e\n",
"SourceHash": "8b236e31c24755fe99eb3c625a54e3637e330fe128877959f8e9d54f2b3844cc",
"ContentHash": "04df83eee0aeda1c9fc8a922db14e4bca81d5f1d932b3fef00afb2ad0be14f55",
"Payload": {
"description": "支持 upsert 功能，当遇到冲突时可以选择不执行任何操作，或将 INSERT 转换为 UPDATE。\n\n更多信息请参阅 [INSERT](https://www.postgresql.org/docs/current/sql-insert.html) 文档。"
}
}
],
"GroupTitles": {
"en": "SQL"
},
"RelatedKey": "upsert-insert-on-conflict-do"
}