column or index collation

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: column or index collation
Date: 2011-12-29 19:12:52
Message-ID: 20111229201252.4b5ffd4c@anubis.defcon1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Jean-Yves F. Barbier 2011-12-29 20:59:26 Re: column or index collation [SOLVED]
Previous Message Jean-Yves F. Barbier 2011-12-29 16:37:09 Re: > and >= give the same result