Skip site navigation (1) Skip section navigation (2)

ORDER BY Problem...

From: Severin Olloz <S(dot)Olloz(at)soid(dot)ch>
To: pgsql-hackers(at)postgresql(dot)org
Subject: ORDER BY Problem...
Date: 2001-06-06 00:55:50
Message-ID: 9fjv1j$mg8$1@news.imp.ch (view raw or flat)
Thread:
Lists: pgsql-hackers
Hello...

Why does Postgresql order the uppercase letters first?

I have e.g. a table with one row an in this row there are follow values:

row1
----
ADC
aa
ABC

With this select-syntax 

select * from table order by row1

I become this output

ABC
ADC
aa

but I want this ouptut:

aa
ABC
ADC

What do I wrong?

-- 
Gruss: Severin Olloz

Responses

pgsql-hackers by date

Next:From: Christopher Kings-LynneDate: 2001-06-06 01:44:24
Subject: RE: Imperfect solutions
Previous:From: Chris DunlopDate: 2001-06-06 00:43:16
Subject: Re: Australian timezone configure option

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group