Thread: different language indexes

different language indexes

From
Dennis Gearon
Date:
Since a DATABASE in Pgsql is the lowest level of objects that can be assigned a collation, I'm wondering if there is a
wayaround it. 

Can indexes be made which have their own individual collations?

I'm thinking to make a table in a datbase that has either us_en-utf8 or 'c' collation, and then put any language that I
wantin it. Then make different indexes using differnt collations. So when I get a user's locality and langauge, I
searchfor the closest index, and specifiy it when doing text based searches. 

Is this possible?


Dennis Gearon

Signature Warning
----------------
EARTH has a Right To Life,
  otherwise we all die.

Read 'Hot, Flat, and Crowded'
Laugh at http://www.yert.com/film.php