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. Please let me know, if I need to provide some more info Thanks Anubha -- This message posted from opensolaris.org
