RES: Issue on Varchar Ordering

OS Debian 3.1

Show lc_collate:

"pt_BR.ISO-8859-1"

It returns:
GABRIELA HELEDA DE SOUZA
GABRIELA JACOBY NOS
GABRIEL ALCIDES KLIM PERONDI
GABRIELA LETICIA BATISTA NUNES
GABRIEL ALEXANDRE DA SILVA MANICA

The correct would be:

GABRIEL ALCIDES KLIM PERONDI
GABRIEL ALEXANDRE DA SILVA MANICA
GABRIELA HELEDA DE SOUZA
GABRIELA JACOBY NOS
GABRIELA LETICIA BATISTA NUNES

As I told you, with OS Windows, it works correctly...

Erika Terahata T. P. e Silva

-----Mensagem original-----
De: Peter Eisentraut [mailto:peter_e(at)gmx(dot)net]
Enviada em: sexta-feira, 18 de agosto de 2006 02:58
Para: pgsql-admin(at)postgresql(dot)org
Cc: Alvaro Herrera; Erika Terahata Torres Prada e Silva - MPS
Assunto: Re: RES: RES: [ADMIN] Issue on Varchar Ordering

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/