ORDER BY Problem...

Severin Olloz wrote:

Why does Postgresql order the uppercase letters first?

Do you have any LOCALE configuration in place?

--
Alessio F. Bragadini alessio@albourne.com
APL Financial Services http://village.albourne.com
Nicosia, Cyprus phone: +357-2-755750

"It is more complicated than you think"
-- The Eighth Networking Truth from RFC 1925

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)

As far as I know, this is the standard (ASCII-ordered) way of sorting text.
For example, MySQL does the same thing.

Chris

"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> 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.

Christopher Kings-Lynne wrote:

As far as I know, this is the standard (ASCII-ordered) way of sorting text.
For example, MySQL does the same thing.

Actually it seems that Severin is using the ASCII locale instead of
en_US or
some other case-insensitive one.

but I want this ouptut:

aa
ABC
ADC

What do I wrong?

-----------
Hannu