to_number

Converts string to numeric according to the given format.

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.1 7.2 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: formatting
group label: 数据类型格式化函数
lang: en
layout: table-new
pages: functions-formatting.html
prose only: false

Definition PG 18

Converts string to numeric according to the given format.

Signatures and overloads

to_number ( text, text ) → numeric → numeric

Converts string to numeric according to the given format.

Compare versions

Complete source facts

documentation revision

{"inputs":[{"file":"functions-formatting.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"17b479f1cd22bc7308cefeb2a307da2ef41a0e2864a6ef7d229b93257f07ad97","version":"18.7"},{"file":"functions-formatting.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"7819c15fc71d5d2494ecc37cbef3fef041440c894a885e853c7e544c631500b4","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:5f614e11fb85fb131a698437a151216ba1a68c6df6c8c9545bd0d4d71c09a1bc

Text language: en · wiki-repair-20261023:5f614e11fb85fb131a698437a151216ba1a68c6df6c8c9545bd0d4d71c09a1bc