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. Thanks for all your help Regards Anubha -- This message posted from opensolaris.org _______________________________________________ opensolaris-discuss mailing list [email protected]
