How to check, if a value is an integer with plpgsql?

sql database postgresql plpgsql

SELECT  current_setting('myvar.user') ~ '^[0-9]+$'

sql database postgresql plpgsql

CREATE FUNCTION isnumeric(text) RETURNS boolean AS 'SELECT $1 ~ ''^[0-9]+$''' LANGUAGE 'sql';

CodeHunter