- Архив списков рассылки pgsql-general

Hello Postgres Gurus!

In the German language we have special characters like
Ä (Ä), Ö (Ö), Ü (Ü), ß (ß) and so on.

I have 5 entries in a table "entries" with one varchar column "name":

select name from entries;
Birnen
Äpfel
Öl
Essig
Salz

I like to sort these entries by name:

select name from entries order by name;
Birnen
Essig
Salz
Äpfel
Öl

But instead of using the standard alphabet
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z Ä Ö Ü ß
for sorting the strings I would like to use the German alphabet
A Ä B C D E F G H I J K L M N O Ö P Q R S ß T U Ü V W X Y Z
to get the correct (sorted by German alphabet) result:

this would be my preferred result: ==>
select name from entries order by name;
Äpfel
Birnen
Essig
Öl
Salz

Can I do this with PostgreSQL?

Thanks,
Alex

--
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net