菜单查询(显示路径名)

select pp.id 
,      pp."name" 
,      pp.parent_path 
,(select  string_agg(name,'/') as path_name from   ir_ui_menu ium where id::text in   
             (select * from   regexp_split_to_table((select parent_path from ir_ui_menu ium  where id=pp.id),'/')))  path_name
, pp.web_icon 
, pp."action" 
             from ir_ui_menu pp  
where lower( pp.name) like '%orders%'