Re: How can I tell, in a trigger, if a value in a string is an integer.

[Tomasz Myrta <jasiek@xxxxxxxxxxx>]

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

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general