Re: How can I tell, in a trigger, if a value in a string is an integer. - Mailing list pgsql-general

Philip W. Dalrymple napisal 29.10.2008 15:26:

>  set_config('session.sessionid','23',false);

I validate strings with regexp. This expression returns true:

select '23' ~'^-{0,1}[0-9]+$';

If it's true - you can cast it safely:
select cast('23' as integer)

--
Regards,
Tomasz Myrta