From: | "Reinoud van Leeuwen" <reinoud(at)xs4all(dot)nl> |
---|---|
To: | <S(dot)Olloz(at)soid(dot)ch> |
Cc: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: ORDER BY Problem... |
Date: | 2001-06-06 12:29:25 |
Message-ID: | 1194.194.109.0.126.991830565.squirrel@webmail2.xs4all.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> 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
------
ABCD
AD
Abc
(3 rows)
# select * from test order by upper(col1);
col1
------
Abc
ABCD
AD
(3 rows)
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Naeslund(f) | 2001-06-06 13:59:13 | vacuumdb -a -z hangs |
Previous Message | Reinoud van Leeuwen | 2001-06-06 12:24:41 | Re: capturing stored procedure return values from php??please help . |