{"Entry":{"collection":"func","key":"pg-input-is-valid","name":"pg_input_is_valid","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"15","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"16"}],"content_hash":"992eabb62c0208b2026d0991e4d9ea98b9b0075e2ac517feb8187b35eb2cd43a","first_version":"16","group":"info","group_label":"System Information Functions And Operators","groups":["info"],"imported_at":"2026-09-27T17:57:29.256159+08:00","last_version":"20","name":"pg_input_is_valid","name_key":"pg_input_is_valid","position":28085,"present_in":["16","17","18","19","20"],"signature":"pg_input_is_valid ( string text, type text ) → boolean","signature_count":1,"slug":"pg-input-is-valid","source_rev":"b7bd9cda","summary":"Tests whether the given string is valid input for the specified data type, returning true or false.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-input-is-valid","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"pg-input-is-valid","SourceRevision":"b7bd9cda","Facts":{"description":"Tests whether the given string is valid input for the specified data type, returning true or false.","description_html":"Tests whether the given \u003cem class=\"parameter\"\u003e\u003ccode\u003estring\u003c/code\u003e\u003c/em\u003e is valid input for the specified data type, returning true or false.","description_zh":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-INFO-VALIDITY-TABLE","file":"functions-info.html","slug":"18"},"group":"info","group_label":"System Information Functions And Operators","lang":"en","layout":"table-new","pages":["functions-info.html"],"prose_only":false,"signatures":[{"description":"Tests whether the given string is valid input for the specified data type, returning true or false.","description_html":"Tests whether the given \u003cem class=\"parameter\"\u003e\u003ccode\u003estring\u003c/code\u003e\u003c/em\u003e is valid input for the specified data type, returning true or false.","description_zh":"","description_zh_html":"","examples":[{"expr":"pg_input_is_valid('42', 'integer')","result":"t"},{"expr":"pg_input_is_valid('42000000000', 'integer')","result":"f"},{"expr":"pg_input_is_valid('1234.567', 'numeric(7,4)')","result":"f"}],"html":"\u003ccode class=\"function\"\u003epg_input_is_valid\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003estring\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003eboolean\u003c/code\u003e","returns":"boolean","text":"pg_input_is_valid ( string text, type text ) → boolean","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-INFO-VALIDITY-TABLE","file":"functions-info.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-input-is-valid","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_input_is_valid","Summary":"测试给定的string是否是指定数据类型的有效输入，返回 true 或 false。","BodyHTML":"测试给定的\u003cem\u003e\u003ccode\u003estring\u003c/code\u003e\u003c/em\u003e是否是指定数据类型的有效输入，返回 true 或 false。\u003cpre\u003epg_input_is_valid ( string text, type text ) → boolean\u003c/pre\u003e测试给定的\u003cem\u003e\u003ccode\u003estring\u003c/code\u003e\u003c/em\u003e是否是指定数据类型的有效输入，返回 true 或 false。","SourceRevision":"ca936764","ContentHash":"b983febce0352b1ff9e1734298adf67a8cb834b5a480d9455b939cdb111215ef","Payload":{"description_zh":"测试给定的string是否是指定数据类型的有效输入，返回 true 或 false。","description_zh_html":"测试给定的\u003cem class=\"parameter\"\u003e\u003ccode\u003estring\u003c/code\u003e\u003c/em\u003e是否是指定数据类型的有效输入，返回 true 或 false。","signatures":[{"description_zh":"测试给定的string是否是指定数据类型的有效输入，返回 true 或 false。","description_zh_html":"测试给定的\u003cem class=\"parameter\"\u003e\u003ccode\u003estring\u003c/code\u003e\u003c/em\u003e是否是指定数据类型的有效输入，返回 true 或 false。","returns":"boolean","text":"pg_input_is_valid ( string text, type text ) → boolean","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"2a63ab1da42e2e06f854c56f00bdcdc4f8fdd1a42deec6c3109d80709869c3cb","Text":"pg_input_is_valid ( string text, type text ) → boolean","Returns":"boolean","Payload":{"description":"Tests whether the given string is valid input for the specified data type, returning true or false.","description_html":"Tests whether the given \u003cem class=\"parameter\"\u003e\u003ccode\u003estring\u003c/code\u003e\u003c/em\u003e is valid input for the specified data type, returning true or false.","description_zh":"","description_zh_html":"","examples":[{"expr":"pg_input_is_valid('42', 'integer')","result":"t"},{"expr":"pg_input_is_valid('42000000000', 'integer')","result":"f"},{"expr":"pg_input_is_valid('1234.567', 'numeric(7,4)')","result":"f"}],"html":"\u003ccode class=\"function\"\u003epg_input_is_valid\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003estring\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003etype\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003eboolean\u003c/code\u003e","returns":"boolean","text":"pg_input_is_valid ( string text, type text ) → boolean","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}