pg_input_is_valid

Tests whether the given string is valid input for the specified data type, returning true or false.

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

16 17 18 19 20

group: info
group label: 系统信息函数和操作符
lang: en
layout: table-new
pages: functions-info.html
prose only: false

Definition PG 18

Tests whether the given string is valid input for the specified data type, returning true or false.

Signatures and overloads

pg_input_is_valid ( string text, type text ) → boolean → boolean

Tests whether the given string is valid input for the specified data type, returning true or false.

Compare versions

Complete source facts

documentation revision

{"inputs":[{"file":"functions-info.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"64499116227a087138bb14f29ff6652b200a176d5df3ce2a089c3d5c226b19b3","version":"18.7"},{"file":"functions-info.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"f9684137c0b9fb17a691c4d905529d114472a507a007c15058f2703962b611d2","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:a88f3c0d31a6750a99bb72913b7e45996c1e8d70396a369893df3c8332788333

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