PostgreSQl 批量更新语句

with tab3 as (with tab1 as (
   select org_id,  
          org_name
   from sys_org where
org_type = '1'
and org_code is not null
),
tab2 as (
   select se.* from sys_enterprise se 
   left join sys_enterprise_org seo on seo.enterprise_id = se.enterprise_id  
)
select tab1.org_id,tab1.org_name, tab2.enterprise_id, tab2.name
from tab1,tab2 where tab2.name like tab1.org_name || '%')
update sys_enterprise_org set org_id = tab3.org_id from tab3 where sys_enterprise_org.enterprise_id = tab3.enterprise_id;