select coalesce(SUBSTRING(xm, '^([\u4e00-\u9fa5]{1,20}|([\u4e00-\u9fa5]{1,20}·[\u4e00-\u9fa5]{1,20}))$'),'111') ;
pg库对姓名进行校验
于 2022-01-26 15:29:04 首次发布
select coalesce(SUBSTRING(xm, '^([\u4e00-\u9fa5]{1,20}|([\u4e00-\u9fa5]{1,20}·[\u4e00-\u9fa5]{1,20}))$'),'111') ;