> 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?
This will not solve your problem, but a way around this is to sort on upper
(row1):
# select * from test order by col1;col1
------ABCDADAbc
(3 rows)
# select * from test order by upper(col1);col1
------AbcABCDAD
(3 rows)