Re: Issue on Varchar Ordering
От | Jonah H. Harris |
---|---|
Тема | Re: Issue on Varchar Ordering |
Дата | |
Msg-id | 36e682920603290845l3728b0edqd3933573f46ac0a7@mail.gmail.com обсуждение исходный текст |
Ответ на | Issue on Varchar Ordering ("Rodrigo Hjort" <rodrigo.hjort@gmail.com>) |
Ответы |
Re: Issue on Varchar Ordering
|
Список | pgsql-hackers |
I don't think PostgreSQL's sorting it wrong... here's the output of Linux's sort utility: edb82@linux:~> cat test.txt GABRIEL ALEXANDRE DA SILVA MANICA GABRIELA LETICIA BATISTA NUNES GABRIEL ALCIDES KLIM PERONDI GABRIELA JACOBY NOS GABRIELA HELEDA DE SOUZA edb82@linux:~> cat test.txt | sort GABRIELA HELEDA DE SOUZA GABRIELA JACOBY NOS GABRIEL ALCIDES KLIM PERONDI GABRIELA LETICIA BATISTA NUNES GABRIEL ALEXANDRE DA SILVA MANICA edb82@linux:~> psql -c "SELECT * FROM aluno ORDER BY nome" postgresid | nome ----+-----------------------------------36 | GABRIELA HELEDA DE SOUZA37 | GABRIELA JACOBY NOS38 | GABRIEL ALCIDES KLIM PERONDI39| GABRIELA LETICIA BATISTA NUNES40 | GABRIEL ALEXANDRE DA SILVA MANICA (5 rows) -- Jonah H. Harris, Database Internals Architect EnterpriseDB Corporation 732.331.1324
В списке pgsql-hackers по дате отправления: