to_bin

Converts the number to its equivalent two's complement binary 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

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 binary representation.

Signatures and overloads

to_bin ( integer ) → text → text

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

to_bin ( bigint ) → text → text

Converts the number to its equivalent two's complement binary 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:1a06aaae75225449dbf6f736161b432bdfde3f6ab9b3c89aedbd96e10bea6bab

Text language: en · wiki-repair-20261023:1a06aaae75225449dbf6f736161b432bdfde3f6ab9b3c89aedbd96e10bea6bab