Thread: column or index collation

column or index collation

From
"Jean-Yves F. Barbier"
Date:
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.

Re: column or index collation [SOLVED]

From
"Jean-Yves F. Barbier"
Date:
On Thu, 29 Dec 2011 20:12:52 +0100
"Jean-Yves F. Barbier" <12ukwn@gmail.com> wrote:


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

Oops, my bad: unaccent; sornoise for the ry.

--
Sacred cows make great hamburgers.