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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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