Prova così:

select * from desalpilles_frontpage WHERE substring(nome,1,1) regexp '[^[:alpha:]]'