Functions / System Information Functions And Operators

pg_input_is_valid

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

Reading PG 18current·documented in 5 of 27 versions, 16 to 20

Signatures & examples

pg_input_is_valid ( string text, type text ) → boolean

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

pg_input_is_valid('42', 'integer') → t

pg_input_is_valid('42000000000', 'integer') → f

pg_input_is_valid('1234.567', 'numeric(7,4)') → f

Version history 1

Definition snapshot: b7bd9cda · English manual source