{"Entry":{"collection":"func","key":"uuidv7","name":"uuidv7","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"17","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"18"}],"content_hash":"76a0ebfa78bda007f7c92089592994e85a61cf3d765095ff138a395c2d9e39a4","derived_content_hash":"fb2544683bc4acaee8017753f86664d5d40560565c942f72a7b305201d728369","documentation_refresh":{"batch":"20261113","original_source_rev":"wiki-repair-20261023:e685881d1af92d373d8d091d95d78ad0fc30883803cf953bf40b57e632528e01","versions":{"18":"18.7","19":"19rc2"}},"first_version":"18","group":"uuid","group_label":"Uuid Functions","groups":["uuid"],"imported_at":"2026-09-14T21:49:48.756093+08:00","last_version":"20","name":"uuidv7","name_key":"uuidv7","position":14004,"present_in":["18","19","20"],"repair_provenance":{"original_source_revision":"2026-09-14T13:14:25.684213+00:00@99e6866c","receipt_sha256":"4a8bdaa96d7728ddb095898a707daab85d7189f59230e47cca91ed7c913c8704","repair":"wiki-repair-20261023"},"signature":"uuidv7 ( [ shift interval ] ) → uuid","signature_count":1,"slug":"uuidv7","source_rev":"wiki-repair-20261023:e685881d1af92d373d8d091d95d78ad0fc30883803cf953bf40b57e632528e01","summary":"Generates a version 7 (time-ordered) UUID.","summary_zh":""}},"Definition":{"Collection":"func","Key":"uuidv7","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"uuidv7","SourceRevision":"wiki-repair-20261023:e685881d1af92d373d8d091d95d78ad0fc30883803cf953bf40b57e632528e01","Facts":{"description":"Generates a version 7 (time-ordered) UUID. The timestamp is computed using UNIX timestamp with millisecond precision + sub-millisecond timestamp + random. The optional parameter shift will shift the computed timestamp by the given interval. Infinite interval values are not accepted. The shifted timestamp must fall within the range supported by UUID version 7's 48-bit millisecond timestamp field: from 1970-01-01 00:00:00 UTC to approximately year 10889. An error is raised if the resulting timestamp is outside this range.","description_html":"Generates a version 7 (time-ordered) UUID. The timestamp is computed using UNIX timestamp with millisecond precision + sub-millisecond timestamp + random. The optional parameter \u003cem class=\"parameter\"\u003e\u003ccode\u003eshift\u003c/code\u003e\u003c/em\u003e will shift the computed timestamp by the given \u003ccode class=\"type\"\u003einterval\u003c/code\u003e. Infinite interval values are not accepted. The shifted timestamp must fall within the range supported by UUID version 7's 48-bit millisecond timestamp field: from 1970-01-01 00:00:00 UTC to approximately year 10889. An error is raised if the resulting timestamp is outside this range.","description_zh":"生成一个版本 7（按时间排序）的 UUID。其时间戳由 UNIX 时间戳（毫秒精度）加上亚毫秒时间戳和随机值计算得到。可选参数 shift 会按给定的 interval 偏移计算出的时间戳。不接受无穷 interval 值。偏移后的时间戳必须位于 UUID 版本 7 的 48 位毫秒时间戳字段所支持的范围内：从 1970-01-01 00:00:00 UTC 到大约 10889 年。如果结果时间戳超出此范围，则会引发错误。","description_zh_html":"生成一个版本 7（按时间排序）的 UUID。其时间戳由 UNIX 时间戳（毫秒精度）加上亚毫秒时间戳和随机值计算得到。可选参数 \u003cem class=\"parameter\"\u003e\u003ccode\u003eshift\u003c/code\u003e\u003c/em\u003e 会按给定的 \u003ccode class=\"type\"\u003einterval\u003c/code\u003e 偏移计算出的时间戳。不接受无穷 interval 值。偏移后的时间戳必须位于 UUID 版本 7 的 48 位毫秒时间戳字段所支持的范围内：从 1970-01-01 00:00:00 UTC 到大约 10889 年。如果结果时间戳超出此范围，则会引发错误。","doc":{"anchor":"FUNC_UUID_GEN_TABLE","file":"functions-uuid.html","sha256":"1145bc769b573b2bdb5619ef98fc49d54db67f2fe7bd4bec69f14c025e66453c","slug":"18"},"documentation_revision":{"inputs":[{"file":"functions-uuid.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"1145bc769b573b2bdb5619ef98fc49d54db67f2fe7bd4bec69f14c025e66453c","version":"18.7"},{"file":"functions-uuid.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"59821fb93e96c7c39838320986580f60a79cc09b1cd2d8ab9bb738768941e05a","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"},"group":"uuid","group_label":"UUID 函数","lang":"en","layout":"table-new","pages":["functions-uuid.html"],"prose_only":false,"signatures":[{"description":"Generates a version 7 (time-ordered) UUID. The timestamp is computed using UNIX timestamp with millisecond precision + sub-millisecond timestamp + random. The optional parameter shift will shift the computed timestamp by the given interval. Infinite interval values are not accepted. The shifted timestamp must fall within the range supported by UUID version 7's 48-bit millisecond timestamp field: from 1970-01-01 00:00:00 UTC to approximately year 10889. An error is raised if the resulting timestamp is outside this range.","description_html":"Generates a version 7 (time-ordered) UUID. The timestamp is computed using UNIX timestamp with millisecond precision + sub-millisecond timestamp + random. The optional parameter \u003cem class=\"parameter\"\u003e\u003ccode\u003eshift\u003c/code\u003e\u003c/em\u003e will shift the computed timestamp by the given \u003ccode class=\"type\"\u003einterval\u003c/code\u003e. Infinite interval values are not accepted. The shifted timestamp must fall within the range supported by UUID version 7's 48-bit millisecond timestamp field: from 1970-01-01 00:00:00 UTC to approximately year 10889. An error is raised if the resulting timestamp is outside this range.","description_zh":"生成一个版本 7（按时间排序）的 UUID。其时间戳由 UNIX 时间戳（毫秒精度）加上亚毫秒时间戳和随机值计算得到。可选参数 shift 会按给定的 interval 偏移计算出的时间戳。不接受无穷 interval 值。偏移后的时间戳必须位于 UUID 版本 7 的 48 位毫秒时间戳字段所支持的范围内：从 1970-01-01 00:00:00 UTC 到大约 10889 年。如果结果时间戳超出此范围，则会引发错误。","description_zh_html":"生成一个版本 7（按时间排序）的 UUID。其时间戳由 UNIX 时间戳（毫秒精度）加上亚毫秒时间戳和随机值计算得到。可选参数 \u003cem class=\"parameter\"\u003e\u003ccode\u003eshift\u003c/code\u003e\u003c/em\u003e 会按给定的 \u003ccode class=\"type\"\u003einterval\u003c/code\u003e 偏移计算出的时间戳。不接受无穷 interval 值。偏移后的时间戳必须位于 UUID 版本 7 的 48 位毫秒时间戳字段所支持的范围内：从 1970-01-01 00:00:00 UTC 到大约 10889 年。如果结果时间戳超出此范围，则会引发错误。","examples":[{"expr":"uuidv7()","result":"019535d9-3df7-79fb-b466-fa907fa17f9e"}],"html":"\u003ccode class=\"function\"\u003euuidv7\u003c/code\u003e ( [\u003cspan class=\"optional\"\u003e\u003cem class=\"parameter\"\u003e\u003ccode\u003eshift\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einterval\u003c/code\u003e\u003c/span\u003e] ) → \u003ccode class=\"returnvalue\"\u003euuid\u003c/code\u003e","returns":"uuid","text":"uuidv7 ( [shift interval] ) → uuid","zh_from":"same-version-manual"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/functions-uuid.html","sha256":"151c63c49d5c4d62b5b90376ab82e5db7c6370a7daa7d58eb51c7b482156efdc"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"FUNC_UUID_GEN_TABLE","file":"functions-uuid.html","sha256":"1145bc769b573b2bdb5619ef98fc49d54db67f2fe7bd4bec69f14c025e66453c","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"uuidv7","SourceDatabase":"center","Version":"18","Locale":"en","Title":"uuidv7","Summary":"Generates a version 7 (time-ordered) UUID. The timestamp is computed using UNIX timestamp with millisecond precision + sub-millisecond timestamp + random. The optional parameter shift will shift the computed timestamp by the given interval. Infinite interval values are not accepted. The shifted timestamp must fall within the range supported by UUID version 7's 48-bit millisecond timestamp field: from 1970-01-01 00:00:00 UTC to approximately year 10889. An error is raised if the resulting timestamp is outside this range.","BodyHTML":"Generates a version 7 (time-ordered) UUID. The timestamp is computed using UNIX timestamp with millisecond precision + sub-millisecond timestamp + random. The optional parameter \u003cem\u003e\u003ccode\u003eshift\u003c/code\u003e\u003c/em\u003e will shift the computed timestamp by the given \u003ccode\u003einterval\u003c/code\u003e. Infinite interval values are not accepted. The shifted timestamp must fall within the range supported by UUID version 7\u0026#39;s 48-bit millisecond timestamp field: from 1970-01-01 00:00:00 UTC to approximately year 10889. An error is raised if the resulting timestamp is outside this range.","SourceRevision":"wiki-repair-20261023:e685881d1af92d373d8d091d95d78ad0fc30883803cf953bf40b57e632528e01","ContentHash":"45c0f43819571dffd9fdaab94208ed73e38fb3a636876089af4e96622840a1d4","Payload":{"description":"Generates a version 7 (time-ordered) UUID. The timestamp is computed using UNIX timestamp with millisecond precision + sub-millisecond timestamp + random. The optional parameter shift will shift the computed timestamp by the given interval. Infinite interval values are not accepted. The shifted timestamp must fall within the range supported by UUID version 7's 48-bit millisecond timestamp field: from 1970-01-01 00:00:00 UTC to approximately year 10889. An error is raised if the resulting timestamp is outside this range.","description_html":"Generates a version 7 (time-ordered) UUID. The timestamp is computed using UNIX timestamp with millisecond precision + sub-millisecond timestamp + random. The optional parameter \u003cem class=\"parameter\"\u003e\u003ccode\u003eshift\u003c/code\u003e\u003c/em\u003e will shift the computed timestamp by the given \u003ccode class=\"type\"\u003einterval\u003c/code\u003e. Infinite interval values are not accepted. The shifted timestamp must fall within the range supported by UUID version 7's 48-bit millisecond timestamp field: from 1970-01-01 00:00:00 UTC to approximately year 10889. An error is raised if the resulting timestamp is outside this range.","signatures":[{"description":"Generates a version 7 (time-ordered) UUID. The timestamp is computed using UNIX timestamp with millisecond precision + sub-millisecond timestamp + random. The optional parameter shift will shift the computed timestamp by the given interval. Infinite interval values are not accepted. The shifted timestamp must fall within the range supported by UUID version 7's 48-bit millisecond timestamp field: from 1970-01-01 00:00:00 UTC to approximately year 10889. An error is raised if the resulting timestamp is outside this range.","description_html":"Generates a version 7 (time-ordered) UUID. The timestamp is computed using UNIX timestamp with millisecond precision + sub-millisecond timestamp + random. The optional parameter \u003cem class=\"parameter\"\u003e\u003ccode\u003eshift\u003c/code\u003e\u003c/em\u003e will shift the computed timestamp by the given \u003ccode class=\"type\"\u003einterval\u003c/code\u003e. Infinite interval values are not accepted. The shifted timestamp must fall within the range supported by UUID version 7's 48-bit millisecond timestamp field: from 1970-01-01 00:00:00 UTC to approximately year 10889. An error is raised if the resulting timestamp is outside this range.","description_zh":"生成一个版本 7（按时间排序）的 UUID。其时间戳由 UNIX 时间戳（毫秒精度）加上亚毫秒时间戳和随机值计算得到。可选参数 shift 会按给定的 interval 偏移计算出的时间戳。不接受无穷 interval 值。偏移后的时间戳必须位于 UUID 版本 7 的 48 位毫秒时间戳字段所支持的范围内：从 1970-01-01 00:00:00 UTC 到大约 10889 年。如果结果时间戳超出此范围，则会引发错误。","description_zh_html":"生成一个版本 7（按时间排序）的 UUID。其时间戳由 UNIX 时间戳（毫秒精度）加上亚毫秒时间戳和随机值计算得到。可选参数 \u003cem class=\"parameter\"\u003e\u003ccode\u003eshift\u003c/code\u003e\u003c/em\u003e 会按给定的 \u003ccode class=\"type\"\u003einterval\u003c/code\u003e 偏移计算出的时间戳。不接受无穷 interval 值。偏移后的时间戳必须位于 UUID 版本 7 的 48 位毫秒时间戳字段所支持的范围内：从 1970-01-01 00:00:00 UTC 到大约 10889 年。如果结果时间戳超出此范围，则会引发错误。","examples":[{"expr":"uuidv7()","result":"019535d9-3df7-79fb-b466-fa907fa17f9e"}],"html":"\u003ccode class=\"function\"\u003euuidv7\u003c/code\u003e ( [\u003cspan class=\"optional\"\u003e\u003cem class=\"parameter\"\u003e\u003ccode\u003eshift\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einterval\u003c/code\u003e\u003c/span\u003e] ) → \u003ccode class=\"returnvalue\"\u003euuid\u003c/code\u003e","returns":"uuid","text":"uuidv7 ( [shift interval] ) → uuid","zh_from":"same-version-manual"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["18","19","20"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"346c17e4019821e881c8c44b9e20f1989f0a2ff0fd83ea340ecf19311f23cd0c","Text":"uuidv7 ( [shift interval] ) → uuid","Returns":"uuid","Payload":{"description":"Generates a version 7 (time-ordered) UUID. The timestamp is computed using UNIX timestamp with millisecond precision + sub-millisecond timestamp + random. The optional parameter shift will shift the computed timestamp by the given interval. Infinite interval values are not accepted. The shifted timestamp must fall within the range supported by UUID version 7's 48-bit millisecond timestamp field: from 1970-01-01 00:00:00 UTC to approximately year 10889. An error is raised if the resulting timestamp is outside this range.","description_html":"Generates a version 7 (time-ordered) UUID. The timestamp is computed using UNIX timestamp with millisecond precision + sub-millisecond timestamp + random. The optional parameter \u003cem class=\"parameter\"\u003e\u003ccode\u003eshift\u003c/code\u003e\u003c/em\u003e will shift the computed timestamp by the given \u003ccode class=\"type\"\u003einterval\u003c/code\u003e. Infinite interval values are not accepted. The shifted timestamp must fall within the range supported by UUID version 7's 48-bit millisecond timestamp field: from 1970-01-01 00:00:00 UTC to approximately year 10889. An error is raised if the resulting timestamp is outside this range.","description_zh":"生成一个版本 7（按时间排序）的 UUID。其时间戳由 UNIX 时间戳（毫秒精度）加上亚毫秒时间戳和随机值计算得到。可选参数 shift 会按给定的 interval 偏移计算出的时间戳。不接受无穷 interval 值。偏移后的时间戳必须位于 UUID 版本 7 的 48 位毫秒时间戳字段所支持的范围内：从 1970-01-01 00:00:00 UTC 到大约 10889 年。如果结果时间戳超出此范围，则会引发错误。","description_zh_html":"生成一个版本 7（按时间排序）的 UUID。其时间戳由 UNIX 时间戳（毫秒精度）加上亚毫秒时间戳和随机值计算得到。可选参数 \u003cem class=\"parameter\"\u003e\u003ccode\u003eshift\u003c/code\u003e\u003c/em\u003e 会按给定的 \u003ccode class=\"type\"\u003einterval\u003c/code\u003e 偏移计算出的时间戳。不接受无穷 interval 值。偏移后的时间戳必须位于 UUID 版本 7 的 48 位毫秒时间戳字段所支持的范围内：从 1970-01-01 00:00:00 UTC 到大约 10889 年。如果结果时间戳超出此范围，则会引发错误。","examples":[{"expr":"uuidv7()","result":"019535d9-3df7-79fb-b466-fa907fa17f9e"}],"html":"\u003ccode class=\"function\"\u003euuidv7\u003c/code\u003e ( [\u003cspan class=\"optional\"\u003e\u003cem class=\"parameter\"\u003e\u003ccode\u003eshift\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einterval\u003c/code\u003e\u003c/span\u003e] ) → \u003ccode class=\"returnvalue\"\u003euuid\u003c/code\u003e","returns":"uuid","text":"uuidv7 ( [shift interval] ) → uuid","zh_from":"same-version-manual"}}],"Spellings":null,"SQLState":null,"Evidence":null}