Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group