Function is_real

The function checks strings for being of data type REAL.

Examples

SELECT is_real('123.456') AS res;

Result:

res
t

SELECT is_real('123,456') AS res;
-- Result is false

Result:

res
f