November 19, 2026: PostgreSQL 19 Released!
Supported Versions: Current (19)
Development Versions: devel

9.14. TID Functions #

Table 9.45 lists functions for the tid data type (tuple identifier).

Table 9.45. TID Functions

Function

Description

Example(s)

tid_block ( tid ) → bigint

Extracts the block number from a tuple identifier.

tid_block('(42,7)'::tid) → 42

tid_offset ( tid ) → integer

Extracts the tuple offset within the block from a tuple identifier.

tid_offset('(42,7)'::tid) → 7


Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.