Re:

On Mon, Jan 14, 2002 at 04:05:37PM +0100, amk@gmx.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@Fam-Meskes.De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!