Function is_smallint

The function checks strings for being of data type SMALLINT.

Examples

SELECT is_smallint('123') AS res;
-- Result is true

Result:

res
t

SELECT is_smallint('123.456') AS res;
-- Result is false

Result:

res
f