to_oct

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

Signatures and overloads

to_oct ( integer ) → text → text

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

to_oct ( bigint ) → text → text

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

Text language: en · wiki-repair-20261023:bd72a683627141ae80f82905c820761a82a6b02ef53d3685be16f7d532986489