Anubha napsal(a): > Actually this is more a postgres question than a Solaris Ques? I am too new > to both Solaris and postgres, so please bear with me. > > I am installing postgres on Solaris. For that I am using initdb. > > My Objective: I want all queries that execute with ‘ORDER BY’ clause, to be > case-insensitive. So that, while sorting, the small ‘a’ and capital ‘A’, are > together. > My Assumption: Some value for locale or LC_COLLATE in initdb command will > help me do this > My Problem: What should be that value? The locale value that I need to > mention with initdb is what, creating problem. So I need to have a locale > value for, I guess, LC_COLLATE which will help me do this. This is my guess.
PostgreSQL uses system locales and collations. If you interesting to have case insensitive sorting you need to do something like "ORDER BY uppercase(mycol)" or you can look on http://pgfoundry.org/projects/citext/ Zdenek PS: Next time you should use [EMAIL PROTECTED] Zdenek _______________________________________________ opensolaris-discuss mailing list [email protected]
