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

• Re: ORDER BY Problem... at 2001-06-06 08:47:44 from Alessio Bragadini
• Re: ORDER BY Problem... at 2001-06-06 12:29:25 from Reinoud van Leeuwen
• RE: ORDER BY Problem... at 2001-06-07 02:10:12 from Christopher Kings-Lynne

pgsql-hackers by date

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