Re: Sensitive sort problem? - Mailing list pgsql-admin

From Donald Fraser
Subject Re: Sensitive sort problem?
Date
Msg-id 007001c3b37c$e426a3c0$1664a8c0@DEMOLITION
Whole thread Raw
In response to Sensitive sort problem?  ("Andrei Bintintan" <klodoma@ar-sd.net>)
List pgsql-admin
----- Original Message -----
> "Donald Fraser" <demolish@cwgsy.net> writes:
> > PostgreSQL 7.3.x and anything below has never had case insensitive sorting
=
> > - period.
>
> This is incorrect.  In point of fact it will depend on the locale the
> database is running under.  I think the OP's problem is he re-initdb'd
> without noting what locale setting was active.

Correction noted.
I over-looked the fact that a local setting can provide different collation
ordering.

Out of interest, which local settings will give a case-insensitive collation
order?

Regards
Donald Fraser



pgsql-admin by date:

Previous
From: William Yu
Date:
Subject: Re: Compiling --with-openssl on Red Hat 9
Next
From: Stephan Szabo
Date:
Subject: Re: Sensitive sort problem?