| From: | Dennis Gearon <gearond(at)sbcglobal(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | different language indexes |
| Date: | 2010-07-01 23:44:56 |
| Message-ID: | 197128.76674.qm@web82108.mail.mud.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Since a DATABASE in Pgsql is the lowest level of objects that can be assigned a collation, I'm wondering if there is a way around 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 want in it. Then make different indexes using differnt collations. So when I get a user's locality and langauge, I search for 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Arnaud Lesauvage | 2010-07-02 06:10:40 | Re: Prevent characters not transposable to LATIN9 |
| Previous Message | Stephen Denne | 2010-07-01 23:39:04 | Help with pgAndroid Contest |