Postgres Pro
Downloads
Home   >   mailing lists

ORDER BY Problem... - Mailing list pgsql-hackers

From Severin Olloz
Subject ORDER BY Problem...
Date
Msg-id 9fjv1j$mg8$1@news.imp.ch
Whole thread Raw
Responses Re: ORDER BY Problem...  ("Reinoud van Leeuwen" <reinoud@xs4all.nl>)
RE: ORDER BY Problem...  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: prasanna venkatesan
Date:
Subject: capturing stored procedure return values from php??please help .
Next
From: "Reinoud van Leeuwen"
Date:
Subject: Re: ORDER BY Problem...