"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> As far as I know, this is the standard (ASCII-ordered) way of sorting text.
No, it's the "we don't know anything about text, but we can compare
their numeric values" approach.
--
Trond Eivind Glomsrød
Red Hat, Inc.
> 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
> a
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
