{"Entry":{"collection":"func","key":"pg-xlogfile-name-offset","name":"pg_xlogfile_name_offset","aliases":[],"metadata":{"changed_in":["9.4"],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"8.1","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"8.2"},{"descriptions_changed":false,"doc_overhaul":false,"from":"9.3","group_changed":null,"signatures":{"added":["pg_xlogfile_name_offset ( location pg_lsn ) → text, integer"],"removed":["pg_xlogfile_name_offset ( location text ) → text, integer"]},"status":"changed","to":"9.4"},{"descriptions_changed":false,"doc_overhaul":false,"from":"9.6","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"removed","to":"10"}],"content_hash":"3d5341799aecaa999a1f8c1f3d4cdd0a0fe3ae7b752d064df4d4a4d81caf9538","first_version":"8.2","group":"admin","group_label":"System Administration Functions","groups":["admin"],"imported_at":"2026-09-27T17:57:29.725457+08:00","last_version":"9.6","name":"pg_xlogfile_name_offset","name_key":"pg_xlogfile_name_offset","position":29122,"present_in":["8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"signature":"pg_xlogfile_name_offset ( location pg_lsn ) → text, integer","signature_count":1,"slug":"pg-xlogfile-name-offset","source_rev":"b7bd9cda","summary":"Convert transaction log location string to file name and decimal byte offset within file","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-xlogfile-name-offset","SourceDatabase":"center","Version":"9.6","SourceTable":"func","SourceKey":"pg-xlogfile-name-offset","SourceRevision":"b7bd9cda","Facts":{"description":"Convert transaction log location string to file name and decimal byte offset within file","description_html":"Convert transaction log location string to file name and decimal byte offset within file","description_zh":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-ADMIN-BACKUP-TABLE","file":"functions-admin.html","slug":"9.6"},"group":"admin","group_label":"System Administration Functions","lang":"en","layout":"table-old","pages":["functions-admin.html"],"prose_only":false,"signatures":[{"description":"Convert transaction log location string to file name and decimal byte offset within file","description_html":"Convert transaction log location string to file name and decimal byte offset within file","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_xlogfile_name_offset\u003c/code\u003e ( location pg_lsn ) → \u003ccode class=\"returnvalue\"\u003etext, integer\u003c/code\u003e","returns":"text, integer","text":"pg_xlogfile_name_offset ( location pg_lsn ) → text, integer","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-ADMIN-BACKUP-TABLE","file":"functions-admin.html","slug":"9.6"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-xlogfile-name-offset","SourceDatabase":"pgweb","Version":"9.6","Locale":"zh-Hans","Title":"pg_xlogfile_name_offset","Summary":"将事务日志位置字符串转换为文件名和文件内的十进制字节偏移量","BodyHTML":"将事务日志位置字符串转换为文件名和文件内的十进制字节偏移量\u003cpre\u003epg_xlogfile_name_offset ( location pg_lsn ) → text, integer\u003c/pre\u003e将事务日志位置字符串转换为文件名和文件内的十进制字节偏移量","SourceRevision":"ca936764","ContentHash":"e44a4c4d836f4d8c6512790815e83e9e2fea4a35b9a64635a2337d8403fd9b84","Payload":{"description_zh":"将事务日志位置字符串转换为文件名和文件内的十进制字节偏移量","description_zh_html":"将事务日志位置字符串转换为文件名和文件内的十进制字节偏移量","signatures":[{"description_zh":"将事务日志位置字符串转换为文件名和文件内的十进制字节偏移量","description_zh_html":"将事务日志位置字符串转换为文件名和文件内的十进制字节偏移量","returns":"text, integer","text":"pg_xlogfile_name_offset ( location pg_lsn ) → text, integer","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"9.6","Ordinal":0,"Hash":"772521c9f88ac5c562b28da2a61e8a59d47687af7ca096fa1b52e1b5bf1dd958","Text":"pg_xlogfile_name_offset ( location pg_lsn ) → text, integer","Returns":"text, integer","Payload":{"description":"Convert transaction log location string to file name and decimal byte offset within file","description_html":"Convert transaction log location string to file name and decimal byte offset within file","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_xlogfile_name_offset\u003c/code\u003e ( location pg_lsn ) → \u003ccode class=\"returnvalue\"\u003etext, integer\u003c/code\u003e","returns":"text, integer","text":"pg_xlogfile_name_offset ( location pg_lsn ) → text, integer","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}