Postgres Pro
Downloads
Home   >   mailing lists

Re: Issue on Varchar Ordering - Mailing list pgsql-hackers

From Jonah H. Harris
Subject Re: Issue on Varchar Ordering
Date
Msg-id 36e682920603290845l3728b0edqd3933573f46ac0a7@mail.gmail.com
Whole thread Raw
In response to Issue on Varchar Ordering  ("Rodrigo Hjort" <rodrigo.hjort@gmail.com>)
Responses Re: Issue on Varchar Ordering  ("Rodrigo Hjort" <rodrigo.hjort@gmail.com>)
List pgsql-hackers
Tree view 
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 by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: Issue in Mapping varchar datatype of Postgre to Oracle
Next
From: "Rodrigo Hjort"
Date:
Subject: Re: Issue on Varchar Ordering