Function is_integer

The function checks strings for being of data type INTEGER.

Examples

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

Result:

res
t

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