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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
