Function is_numeric

The function checks strings for being of data type NUMERIC.

Examples

SELECT is_numeric('123') AS res;

Result:

res
t

SELECT is_numeric('1 2') AS res;
-- Result is false

Result:

res
f