Postgres Pro
Downloads
Home   >   mailing lists

ORDER BY Problem - Mailing list pgsql-general

From Severin Olloz
Subject ORDER BY Problem
Date
Msg-id 01060603173601.01049@solloz
Whole thread Raw
Responses Re: ORDER BY Problem  ("Eric G. Miller" <egm2@jps.net>)
Re: ORDER BY Problem  (Tod McQuillin <devin@spamcop.net>)
Re: ORDER BY Problem  (teg@redhat.com (Trond Eivind Glomsrød))
List pgsql-general
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?

Thanks: Severin Olloz

pgsql-general by date:

Previous
From: "Tauren Mills"
Date:
Subject: Specifying psql password on command line
Next
From: "Eric G. Miller"
Date:
Subject: Re: Vacuum problems ... HELP !!!