I need to do queries ignoring diacritics (and case) in PostgreSQL 9.3. Everything I've found about it (e.g. here, here and here) requires the installation of the unaccent
extension. However, I cannot have it installed on my server.
Is there another way to do it?