On Wed, Oct 08, 2008 at 01:21:49PM +0200, Zdenek Kotala wrote: > Anubha Khurana napsal(a): > > Thanks for your replies. > > > > Probably I didn't explain my problem well. I am using a third party tool > > which I'll be installing on Solaris machine, and that tool is using > > Postgres as the database. The queries are hardcoded in it and I can not > > change them. So right now when I do 'initdb' without specifying > > '-locale' or '-lc-collate', I see that the 'order by' clause returns me > > 'case sensitive' search. > > > > And therefore the third party tool also returns me case sensitive results. > > > > I need postgres to be installed in a way so that 'order by' clause > > itself returns me 'case-insensitive' search and I don't have to use > > upper() or lower() functions in the query. > > Unfortunately there is no way how to solve it. Ok maybe two ways you can > try. First is create own collation (see localedef) or alter table > definitions and replace text with citext data type.
Ah, OK, so you can define your own collations in PostgreSQL? Excellent, then never mind my reply.
