Check if the input is integer on postgres amazon redshift

4.7k Views Asked by At

I need to check if the input is integer. using postgres on amazon redshift.

The following I tried

select 1,
case when ISNUMERIC(11) -- like  '[0-9][0-9]'
then 'is_num'
else
'non_num'
end as xxx
0

There are 0 best solutions below