PostgreSQl-删除字符串为小写的数据

delete from table where flidname in (
select  flidname from (
select  flidname ,upper(flidname ) upperflidname  from table 
) as a  where flidname !=upperflidname 
)