| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Erika Terahata Torres Prada e Silva - MPS <erika(dot)prada(at)previdencia(dot)gov(dot)br> |
| Subject: | Re: RES: RES: Issue on Varchar Ordering |
| Date: | 2006-08-18 05:57:43 |
| Message-ID: | 200608180757.44585.peter_e@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Alvaro Herrera wrote:
> LC_COLLATE=pt_PT sort << EOF
> GABRIEL ALEXANDRE DA SILVA MANICA
> GABRIELA JACOBY NOS
> GABRIELA HELEDA DE SOUZA
> GABRIELA LETICIA BATISTA NUNES
> GABRIEL ALCIDES KLIM PERONDI
> EOF
>
> On my system it outputs the order you show above, which shows that my
> locale is correctly defined per your expectations.
That is absolutely wild. This will indeed return a space-sensitive sort
under pt_BR, but not under, say, de_DE. So there is order in this
world! (heh)
This is on Debian, so the original poster has some configuration or
version difference. Please tell OS version, and the output of "SHOW
lc_collate".
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2006-08-18 10:54:06 | Re: running PostGres without installing it |
| Previous Message | Tom Lane | 2006-08-18 00:58:01 | Re: LOG: could not receive data from client: Connection reset by peer |