As far as I know, this is the standard (ASCII-ordered) way of sorting text.
For example, MySQL does the same thing.
Chris
> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org]On Behalf Of Severin Olloz
> Sent: Wednesday, 6 June 2001 8:56 AM
> To: pgsql-hackers@postgresql.org
> Subject: [HACKERS] ORDER BY Problem...
>
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>