pg字段支持多个字符串模糊匹配

需求，匹配字段project_name以2或者3结尾的数据

方法一

1、模糊匹配出符合要求的值

 select * from gse_test_project B 
  where project_name like '%3' or project_name like '%2'

 2、不符合模糊匹配的值   

 select * from gse_test_project B 
  where not(project_name like '%3' or project_name like '%2') or project_name is null

方法二

1、模糊匹配出符合要求的值

 select * from gse_test_project B 
  where project_name like any(array['%3','%2'])
                         
 2、不符合模糊匹配的值         
                      
        （1）select * from gse_test_project B 
      where project_name not like all(array['%3','%2']) or project_name is null
        （2）select  * from gse_test_project B 
                where not(project_name like any(array['%3','%2'])) or project_name is null