Hitesh Bagadiya <bagadiya@yahoo.com> writes:
> I set the locale to hi_IN during initdb. pg_controldata and show
> lc_collate both show that locale is hi_IN. But postgresql is not
> returning sorted records.
There's still the other point about whether the database's character
set encoding matches what the locale setting requires.
For that matter, are you certain the locale itself works? Have you
checked that sort(1) produces the sort order you are expecting when
LC_ALL=hi_IN?
regards, tom lane