RES: RES: [ADMIN] Issue on Varchar Ordering

2006-08-18 Thread Erika Terahata Torres Prada e Silva - MPS
Terahata Torres Prada e Silva - MPS Cc: pgsql-admin@postgresql.org Assunto: Re: RES: [ADMIN] Issue on Varchar Ordering Erika Terahata Torres Prada e Silva - MPS wrote: OS Debian 3.1 Show lc_collate: pt_BR.ISO-8859-1 It returns: GABRIELA HELEDA DE SOUZA GABRIELA JACOBY NOS

RES: RES: [ADMIN] Issue on Varchar Ordering

2006-08-17 Thread Erika Terahata Torres Prada e Silva - MPS
: quinta-feira, 17 de agosto de 2006 11:53 Para: Erika Terahata Torres Prada e Silva - MPS Cc: pgsql-admin@postgresql.org Assunto: Re: RES: [ADMIN] Issue on Varchar Ordering Erika Terahata Torres Prada e Silva - MPS wrote: Peter, Thanks for answering. But it's not correct to my language pt_BR

Re: RES: RES: [ADMIN] Issue on Varchar Ordering

2006-08-17 Thread Alvaro Herrera
Erika Terahata Torres Prada e Silva - MPS wrote: Thanks everybody. The correct order in Portuguese would return as brazilian telephone guide order as below: select * from aluno order by nome id nome 38 GABRIEL ALCIDES KLIM PERONDI 40 GABRIEL

Re: RES: RES: [ADMIN] Issue on Varchar Ordering

2006-08-17 Thread Peter Eisentraut
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