Thread: order by

order by

From
Adrian Perez Camarena
Date:
Hello friends
I have the next problem :
I need to order by name a table that contains name and other
fields of users.
I'm in Mexico city and the user's name looks like these:

Select name from prueba_insaculacion order by name;

name
--------------
BELTRAN
DIAZ
HAVEZ
LLUNAS
LOPEZ
NA�ES
NU�EZ
PEREZ
PE�A
YA�ES
�RSATE
�AURIBIA
�NAMUNO

as you can see the order by name is wrong,
mi question is the next:

is there a file of postgres that I can change to tell postgres
that the language that I need to order by name correctly is
spanish? (or something like that)

thanks for your help...

Adrian Perez
IFE


Re: [GENERAL] order by

From
Oleg Broytmann
Date:
On Tue, 29 Feb 2000, Adrian Perez Camarena wrote:
> is there a file of postgres that I can change to tell postgres
> that the language that I need to order by name correctly is
> spanish? (or something like that)

   If I do understand your problem, the solution is here - you should
recompile Postgres with locale support, and run it with correct locale
settings.
   Look more docs on locale support in Postgres sourses and documentation.

Oleg.
----
    Oleg Broytmann     http://members.xoom.com/phd2/     phd2@earthling.net
           Programmers don't die, they just GOSUB without RETURN.