Function is_double_precision

The function checks strings for being of data type DOUBLE PRECISION.

Examples

SELECT is_double_precision('123.456') AS res;

Result:

res
t

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

Result:

res
f