From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
To: | <S(dot)Olloz(at)soid(dot)ch>, <pgsql-hackers(at)postgresql(dot)org> |
Subject: | RE: ORDER BY Problem... |
Date: | 2001-06-07 02:10:12 |
Message-ID: | ECEHIKNFIMMECLEBJFIGCEONCAAA.chriskl@familyhealth.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(at)postgresql(dot)org
> [mailto:pgsql-hackers-owner(at)postgresql(dot)org]On Behalf Of Severin Olloz
> Sent: Wednesday, 6 June 2001 8:56 AM
> To: pgsql-hackers(at)postgresql(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2001-06-07 02:14:13 | RE: place for newbie postgresql hackers to work |
Previous Message | Stephan Szabo | 2001-06-07 01:12:51 | Re: behavior of ' = NULL' vs. MySQL vs. Standards |