Re:

On Mon, Jan 14, 2002 at 04:05:37PM +0100, amk(at)gmx(dot)at wrote:
> Hello Postgres Gurus!
> ...
>
> this would be my preferred result: ==>
> select name from entries order by name;

How about:

mm=# select name from entries order by name;
name
--------
Äpfel
Birnen
Essig
Öl
Salz
(5 rows)

> Can I do this with PostgreSQL?

Sure, as the example above is copied from psql. :-)

Just make sure locale support is compiled into postgresql. That is, I
believe that's all. I cannot remember having to configure anything to get
this going.

Michael

Michael
--
Michael Meskes
Michael(at)Fam-Meskes(dot)De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!