通用唯一标识符
\nuuid 数据类型用于存储由\n RFC 9562、ISO/IEC 9834-8:2005 及相关标准定义的通用唯一标识符（UUID）。（有些系统把这种数据类型称为全局唯一标识符，或 GUID。）这种标识符是一个\n 128 位的量，由某种算法生成，该算法的设计目标是：使已知宇宙中其他人用同一算法生成出相同标识符的概率极低。因此，对于分布式系统而言，这类标识符能比序列生成器提供更好的唯一性保证，因为序列生成器仅在单个数据库内唯一。\n
\n RFC 9562 定义了 8 种不同的 UUID 版本。每个版本对生成新 UUID 值都有各自的要求，也各自具备不同的优缺点。PostgreSQL 原生支持使用 UUIDv4 和\n UUIDv7 算法生成 UUID。或者，也可以在数据库外部使用任意算法生成\n UUID 值。uuid 数据类型可用于存储任何 UUID，无论其来源和版本为何。\n
\n UUID 写作一串小写十六进制数字，并用连字符分隔成若干组：先是 8 位一组，接着是三个 4 位组，最后是一个 12 位组。总共\n 32 个十六进制数字表示 128 个二进制位。标准形式的 UUID\n 例如：\n
\nPostgreSQL 也接受其他输入形式：可以使用大写字母、用花括号包围标准格式、省略部分或全部连字符，或者在任意\n 4 位分组后额外加上连字符。例如：\n
"}, "summary": "通用唯一标识符", "version": "18", "link_map": {"/zh/docs/18/datatype-uuid.html": "/docs/18/datatype-uuid.html"}, "body_html": "通用唯一标识符
\nuuid 数据类型用于存储由\n RFC 9562、ISO/IEC 9834-8:2005 及相关标准定义的通用唯一标识符（UUID）。（有些系统把这种数据类型称为全局唯一标识符，或 GUID。）这种标识符是一个\n 128 位的量，由某种算法生成，该算法的设计目标是：使已知宇宙中其他人用同一算法生成出相同标识符的概率极低。因此，对于分布式系统而言，这类标识符能比序列生成器提供更好的唯一性保证，因为序列生成器仅在单个数据库内唯一。\n
\n RFC 9562 定义了 8 种不同的 UUID 版本。每个版本对生成新 UUID 值都有各自的要求，也各自具备不同的优缺点。PostgreSQL 原生支持使用 UUIDv4 和\n UUIDv7 算法生成 UUID。或者，也可以在数据库外部使用任意算法生成\n UUID 值。uuid 数据类型可用于存储任何 UUID，无论其来源和版本为何。\n
\n UUID 写作一串小写十六进制数字，并用连字符分隔成若干组：先是 8 位一组，接着是三个 4 位组，最后是一个 12 位组。总共\n 32 个十六进制数字表示 128 个二进制位。标准形式的 UUID\n 例如：\n
\nPostgreSQL 也接受其他输入形式：可以使用大写字母、用花括号包围标准格式、省略部分或全部连字符，或者在任意\n 4 位分组后额外加上连字符。例如：\n
", "body_sha256": "76edd9044aff10438b425e68ab9d068360e3498d2275dd2217aa22ff32a239b9", "content_hash": "06a6443e9227099045cdccd66336cd853f53c64e0ec0df8950f450f377f3c770", "source_database": "center", "source_revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "operators": [{"oid": "2972", "descr": "equal", "oprcom": "=(uuid,uuid)", "oprcode": "uuid_eq", "oprjoin": "eqjoinsel", "oprkind": "b", "oprleft": "uuid", "oprname": "=", "oprrest": "eqsel", "oprowner": "POSTGRES", "oprright": "uuid", "oprnegate": "<>(uuid,uuid)", "oprresult": "bool", "oprcanhash": "t", "oprcanmerge": "t", "oprnamespace": "pg_catalog"}, {"oid": "2973", "descr": "not equal", "oprcom": "<>(uuid,uuid)", "oprcode": "uuid_ne", "oprjoin": "neqjoinsel", "oprkind": "b", "oprleft": "uuid", "oprname": "<>", "oprrest": "neqsel", "oprowner": "POSTGRES", "oprright": "uuid", "oprnegate": "=(uuid,uuid)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "2974", "descr": "less than", "oprcom": ">(uuid,uuid)", "oprcode": "uuid_lt", "oprjoin": "scalarltjoinsel", "oprkind": "b", "oprleft": "uuid", "oprname": "<", "oprrest": "scalarltsel", "oprowner": "POSTGRES", "oprright": "uuid", "oprnegate": ">=(uuid,uuid)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "2975", "descr": "greater than", "oprcom": "<(uuid,uuid)", "oprcode": "uuid_gt", "oprjoin": "scalargtjoinsel", "oprkind": "b", "oprleft": "uuid", "oprname": ">", "oprrest": "scalargtsel", "oprowner": "POSTGRES", "oprright": "uuid", "oprnegate": "<=(uuid,uuid)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "2976", "descr": "less than or equal", "oprcom": ">=(uuid,uuid)", "oprcode": "uuid_le", "oprjoin": "scalarlejoinsel", "oprkind": "b", "oprleft": "uuid", "oprname": "<=", "oprrest": "scalarlesel", "oprowner": "POSTGRES", "oprright": "uuid", "oprnegate": ">(uuid,uuid)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "2977", "descr": "greater than or equal", "oprcom": "<=(uuid,uuid)", "oprcode": "uuid_ge", "oprjoin": "scalargejoinsel", "oprkind": "b", "oprleft": "uuid", "oprname": ">=", "oprrest": "scalargesel", "oprowner": "POSTGRES", "oprright": "uuid", "oprnegate": "<(uuid,uuid)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}], "signature": "uuid", "tables_zh": [], "description": ["通用唯一标识符"], "manual_html": "", "manual_path": "datatype-uuid.html", "sections_zh": [], "localization": {"status": "complete", "sources": [{"url": "/docs/18/datatype-uuid.html", "method": "same-major semantic node", "sha256": "7069d17b49583a9c54eae2187aa29e86d36e6a65f04b52d259ce4bc6cda64f1f", "language": "zh", "matched_nodes": ["#DATATYPE-UUID/div[0]", "#DATATYPE-UUID/p[2]", "#DATATYPE-UUID/p[3]", "#DATATYPE-UUID/p[4]", "#DATATYPE-UUID/p[8]", "#DATATYPE-UUID/p[9]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "universally unique identifier", "/versions/18/facts/0/label": "Catalog name", "/versions/18/facts/1/label": "Type OID", "/versions/18/facts/2/label": "Type kind", "/versions/18/facts/2/value": "Base type", "/versions/18/facts/3/label": "Declared length", "/versions/18/facts/3/value": "16 bytes", "/versions/18/facts/4/label": "Storage strategy", "/versions/18/facts/5/label": "Input function", "/versions/18/facts/6/label": "Output function", "/versions/18/related/0/label": "pg_type catalog", "/versions/18/related/1/label": "pg_cast catalog", "/versions/18/related/2/label": "pg_operator catalog", "/versions/18/related/3/label": "pg_opclass catalog", "/versions/18/related/4/label": "Arrays", "/versions/18/related/5/label": "brin index access method", "/versions/18/related/6/label": "btree index access method", "/versions/18/related/7/label": "hash index access method"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "e55531270a70c121366bfbb035651be16daf39aac7f83b34151b695219527194", "canonical_center_text_hash": "06a6443e9227099045cdccd66336cd853f53c64e0ec0df8950f450f377f3c770"}, "description_zh": "通用唯一标识符", "comparison_data": {"casts": [], "facts": [{"label": "Catalog name", "value": "pg_catalog.uuid"}, {"label": "Declared length", "value": "16 bytes"}, {"label": "Input function", "value": "uuid_in"}, {"label": "Output function", "value": "uuid_out"}, {"label": "Storage strategy", "value": "plain"}, {"label": "Type OID", "value": "2950"}, {"label": "Type kind", "value": "Base type"}], "ranges": [], "aliases": [], "catalog": {"typacl": "_null_", "typlen": "16", "typelem": "0", "typname": "uuid", "typsend": "uuid_send", "typtype": "b", "typalign": "c", "typarray": "_uuid", "typbyval": "f", "typdelim": ",", "typinput": "uuid_in", "typmodin": "-", "typndims": "0", "typrelid": "0", "typmodout": "-", "typoutput": "uuid_out", "typtypmod": "-1", "typanalyze": "-", "typdefault": "_null_", "typnotnull": "f", "typreceive": "uuid_recv", "typstorage": "p", "typbasetype": "0", "typcategory": "U", "typcollation": "0", "typisdefined": "t", "typsubscript": "-", "typdefaultbin": "_null_", "typispreferred": "f", "array_type_name": "_uuid"}, "operators": [{"oprcom": "<=(uuid,uuid)", "oprcode": "uuid_ge", "oprjoin": "scalargejoinsel", "oprkind": "b", "oprleft": "uuid", "oprname": ">=", "oprrest": "scalargesel", "oprright": "uuid", "oprnegate": "<(uuid,uuid)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "<(uuid,uuid)", "oprcode": "uuid_gt", "oprjoin": "scalargtjoinsel", "oprkind": "b", "oprleft": "uuid", "oprname": ">", "oprrest": "scalargtsel", "oprright": "uuid", "oprnegate": "<=(uuid,uuid)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": ">=(uuid,uuid)", "oprcode": "uuid_le", "oprjoin": "scalarlejoinsel", "oprkind": "b", "oprleft": "uuid", "oprname": "<=", "oprrest": "scalarlesel", "oprright": "uuid", "oprnegate": ">(uuid,uuid)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": ">(uuid,uuid)", "oprcode": "uuid_lt", "oprjoin": "scalarltjoinsel", "oprkind": "b", "oprleft": "uuid", "oprname": "<", "oprrest": "scalarltsel", "oprright": "uuid", "oprnegate": ">=(uuid,uuid)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "<>(uuid,uuid)", "oprcode": "uuid_ne", "oprjoin": "neqjoinsel", "oprkind": "b", "oprleft": "uuid", "oprname": "<>", "oprrest": "neqsel", "oprright": "uuid", "oprnegate": "=(uuid,uuid)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "=(uuid,uuid)", "oprcode": "uuid_eq", "oprjoin": "eqjoinsel", "oprkind": "b", "oprleft": "uuid", "oprname": "=", "oprrest": "eqsel", "oprright": "uuid", "oprnegate": "<>(uuid,uuid)", "oprresult": "bool", "oprcanhash": "t", "oprcanmerge": "t"}], "operator_classes": [{"opcname": "uuid_bloom_ops", "opcfamily": "brin/uuid_bloom_ops", "opcintype": "uuid", "opcmethod": "brin", "opcdefault": "f", "opckeytype": "uuid"}, {"opcname": "uuid_minmax_multi_ops", "opcfamily": "brin/uuid_minmax_multi_ops", "opcintype": "uuid", "opcmethod": "brin", "opcdefault": "f", "opckeytype": "uuid"}, {"opcname": "uuid_minmax_ops", "opcfamily": "brin/uuid_minmax_ops", "opcintype": "uuid", "opcmethod": "brin", "opcdefault": "t", "opckeytype": "uuid"}, {"opcname": "uuid_ops", "opcfamily": "btree/uuid_ops", "opcintype": "uuid", "opcmethod": "btree", "opcdefault": "t", "opckeytype": "0"}, {"opcname": "uuid_ops", "opcfamily": "hash/uuid_ops", "opcintype": "uuid", "opcmethod": "hash", "opcdefault": "t", "opckeytype": "0"}]}, "comparison_hash": "92eeb626f952aeee0957eb99aa91848335d0d83b0fd80d41549c4673d1288412", "manual_language": "zh", "operator_classes": [{"opcname": "uuid_ops", "opcowner": "POSTGRES", "opcfamily": "btree/uuid_ops", "opcintype": "uuid", "opcmethod": "btree", "opcdefault": "t", "opckeytype": "0", "opcnamespace": "pg_catalog"}, {"opcname": "uuid_ops", "opcowner": "POSTGRES", "opcfamily": "hash/uuid_ops", "opcintype": "uuid", "opcmethod": "hash", "opcdefault": "t", "opckeytype": "0", "opcnamespace": "pg_catalog"}, {"opcname": "uuid_minmax_ops", "opcowner": "POSTGRES", "opcfamily": "brin/uuid_minmax_ops", "opcintype": "uuid", "opcmethod": "brin", "opcdefault": "t", "opckeytype": "uuid", "opcnamespace": "pg_catalog"}, {"opcname": "uuid_minmax_multi_ops", "opcowner": "POSTGRES", "opcfamily": "brin/uuid_minmax_multi_ops", "opcintype": "uuid", "opcmethod": "brin", "opcdefault": "f", "opckeytype": "uuid", "opcnamespace": "pg_catalog"}, {"opcname": "uuid_bloom_ops", "opcowner": "POSTGRES", "opcfamily": "brin/uuid_bloom_ops", "opcintype": "uuid", "opcmethod": "brin", "opcdefault": "f", "opckeytype": "uuid", "opcnamespace": "pg_catalog"}], "description_zh_html": "通用唯一标识符
\nuuid 数据类型用于存储由\n RFC 9562、ISO/IEC 9834-8:2005 及相关标准定义的通用唯一标识符（UUID）。（有些系统把这种数据类型称为全局唯一标识符，或 GUID。）这种标识符是一个\n 128 位的量，由某种算法生成，该算法的设计目标是：使已知宇宙中其他人用同一算法生成出相同标识符的概率极低。因此，对于分布式系统而言，这类标识符能比序列生成器提供更好的唯一性保证，因为序列生成器仅在单个数据库内唯一。\n
\n RFC 9562 定义了 8 种不同的 UUID 版本。每个版本对生成新 UUID 值都有各自的要求，也各自具备不同的优缺点。PostgreSQL 原生支持使用 UUIDv4 和\n UUIDv7 算法生成 UUID。或者，也可以在数据库外部使用任意算法生成\n UUID 值。uuid 数据类型可用于存储任何 UUID，无论其来源和版本为何。\n
\n UUID 写作一串小写十六进制数字，并用连字符分隔成若干组：先是 8 位一组，接着是三个 4 位组，最后是一个 12 位组。总共\n 32 个十六进制数字表示 128 个二进制位。标准形式的 UUID\n 例如：\n
\nPostgreSQL 也接受其他输入形式：可以使用大写字母、用花括号包围标准格式、省略部分或全部连字符，或者在任意\n 4 位分组后额外加上连字符。例如：\n
", "manual_documentation": "dedicated family chapter", "center_zh_rendered": "通用唯一标识符
\nuuid 数据类型用于存储由\n RFC 9562、ISO/IEC 9834-8:2005 及相关标准定义的通用唯一标识符（UUID）。（有些系统把这种数据类型称为全局唯一标识符，或 GUID。）这种标识符是一个\n 128 位的量，由某种算法生成，该算法的设计目标是：使已知宇宙中其他人用同一算法生成出相同标识符的概率极低。因此，对于分布式系统而言，这类标识符能比序列生成器提供更好的唯一性保证，因为序列生成器仅在单个数据库内唯一。\n
\n RFC 9562 定义了 8 种不同的 UUID 版本。每个版本对生成新 UUID 值都有各自的要求，也各自具备不同的优缺点。PostgreSQL 原生支持使用 UUIDv4 和\n UUIDv7 算法生成 UUID。或者，也可以在数据库外部使用任意算法生成\n UUID 值。uuid 数据类型可用于存储任何 UUID，无论其来源和版本为何。\n
\n UUID 写作一串小写十六进制数字，并用连字符分隔成若干组：先是 8 位一组，接着是三个 4 位组，最后是一个 12 位组。总共\n 32 个十六进制数字表示 128 个二进制位。标准形式的 UUID\n 例如：\n
\nPostgreSQL 也接受其他输入形式：可以使用大写字母、用花括号包围标准格式、省略部分或全部连字符，或者在任意\n 4 位分组后额外加上连字符。例如：\n
"}, "from": "17", "comparison": {"available": true, "changes": [], "prose_changed": false}}