unexpected ORDER BY - Mailing list pgsql-sql

From Andreas
Subject unexpected ORDER BY
Date
Msg-id 4CD97004.7070403@gmx.net
Whole thread Raw
Responses Re: unexpected ORDER BY  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Hi,

I've got an PG 8.4 on a opensuse box running.
The DB is unicode german.

There is a text column I'd like to order by but as far as I see PG 
ignores special chars and uses only characters and numbers.
E.g. I get :

S&T C...
S&T E...
STP <-- ???
STP A <-- ???
S&T P...
S&T R...

Can I modify the SELECT or even better switch a global setting that PG 
uses all chars to sort?



pgsql-sql by date:

Previous
From: Will Furnass
Date:
Subject: Re: resolved: WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable
Next
From: Tom Lane
Date:
Subject: Re: unexpected ORDER BY