PostgreSQL 19 Documentation · 9.14. TID Functions

Documentation → PostgreSQL 19

Development versions: 19 / devel

Pre-release documentation. PostgreSQL 19 Beta 3 is a testing release. The final release may differ.

9.14. TID Functions
Prev	Up	Chapter 9. Functions and Operators	Home	Next

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`

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

Prev	Up	Next
9.13. Text Search Functions and Operators	Home	9.15. UUID Functions

Read the upstream documentation. For corrections, first check the current manual.