Answers for "plpgsql check if string is numeric"

plsql check for string in numeric

SELECT case when regexp_like(col1, '^d+(.d+){0, 10}?$') 
            then 'numeric'
            else 'alfa'
      end
FROM  tab1;

Posted by: Guest on May-10-2021

Code answers related to "plpgsql check if string is numeric"