postgre sql 字符串转为integer类型

select cast(setting_value as integer) from ud_organization_setting.

select cast('123123' as integer) from ud_organization_setting.