to_hex

Converts the number to its equivalent two's complement hexadecimal representation.

English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

group: string
group label: 字符串函数和操作符
lang: en
layout: table-new
pages: functions-string.html
prose only: false

Definition PG 18

Converts the number to its equivalent two's complement hexadecimal representation.

Signatures and overloads

to_hex ( integer ) → text → text

Converts the number to its equivalent two's complement hexadecimal representation.

to_hex ( bigint ) → text → text

Converts the number to its equivalent two's complement hexadecimal representation.

Compare versions

Complete source facts

documentation revision

{"inputs":[{"file":"functions-string.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"dbe9f91e55c35969d99a8d2697b6f7bd5388a24ccc2b89706a666f176025f1e2","version":"18.7"},{"file":"functions-string.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"7eecd3bb343149124be0476a539f3c682476eab2a15489a0e0ad06fbb769ea9e","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:9e3af00d844f15423c0957b73303d68f4d09f7fed878776bf68d6b4140818c64

Text language: en · wiki-repair-20261023:9e3af00d844f15423c0957b73303d68f4d09f7fed878776bf68d6b4140818c64