column or index collation - Mailing list pgsql-novice

Debian sid
PG v.9.1.2-1
============

Hi list,

I'd like to be able to perform queries on a table regardless of:

* upper/lower case (found it: index on lower(column) + qry on
  lower(search)),

* any accentuated letter, ie:
  looking for 'chale'
  should return: 'Châle', 'shalé', 'Chàlè', 'čhale', etc.

1- I guess my question has a link to COLLATE, but in which way?
   (does such a collation exists?)

2- Where is it better to apply it, directly to column or just to
   index?

JY
--
Shit Happens.