Re: DIfferent ORDER BY behaviour in 7.4.2

Thanks a lot Tom !!
Locale settings was the problem.

Thanks,
guna.

Tom Lane wrote:

>Gunasekaran Balakrishnan <guna(at)motorola(dot)com> writes:
>
>
>> I am seeing a different sorting behaviour for varchar columns in
>>Postgres 7.4.2.
>>postgres 7.4.2 is ignoring case for varchar columns for "ORDER BY"
>>commands where as 7.2.2 is not.
>>
>>
>
>Check your locale settings.
>
>IIRC, --enable-locale was not default in 7.2 days, but it is default
>(in fact mandatory) now. So it's possible that the 7.2 installation
>doesn't have locale support at all and is defaulting to C-locale
>behavior. If your 7.2 was built with locale support, then it was
>probably initdb'd under a different locale setting than your 7.4 was.
>In 7.4 you can just do "show lc_collate" to check, but in 7.2 I think
>you have to use pg_controldata (or in a pinch, "strings pg_control")
>to find out what locale it's using.
>
> regards, tom lane
>
>
>