Hello,
Does psql provide a function isnumeric(varchar) to check if a varchar
can be converted to a numeric field?
E.g.,
x | isnumeric
----------+-----------
| f
. | f
.0 | t
0. | t
0 | t
1 | t
123 | t
123.456 | t
abc | f
1..2 | f
1.2.3.4 | f
1x234 | f
1.234e-5 | t
Thanks a lot
Emi
--
Found examples users created by self. If psql provides similar one already?