I am writing a pgsql function and I would need to create a condition
based on the value of a text variable. I would need to check if
text_var is convertable to numeric type and if yes do the conversion,
if no do something else. I couldn't find out how to do that.
Something like:
IF isnumeric(text_var) Then
num_var:=Cast (text_var AS numeric);
ELSE
....
END IF;
Thanks for the help.
Balázs