Quick Links

ORDER BY Problem

From:	Severin Olloz <S(dot)Olloz(at)soid(dot)ch>
To:	pgsql-general(at)postgresql(dot)org
Subject:	ORDER BY Problem
Date:	2001-06-06 01:17:36
Message-ID:	01060603173601.01049@solloz
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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?

Thanks: Severin Olloz

Re: ORDER BY Problem at 2001-06-06 02:24:14 from Doug McNaught
Re: ORDER BY Problem at 2001-06-06 02:33:08 from Eric G. Miller
Re: ORDER BY Problem at 2001-06-06 02:45:38 from Tod McQuillin
Re: ORDER BY Problem at 2001-06-06 03:03:12 from Trond Eivind =?iso-8859-1?q?Glomsr=F8d?=

	From	Date	Subject
Next Message	Eric G. Miller	2001-06-06 01:23:54	Re: Vacuum problems ... HELP !!!
Previous Message	Tauren Mills	2001-06-06 01:15:29	RE: Alternate database locations