Received: from ife.org.mx (correo.ife.org.mx [200.34.164.2]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA04145 for ; Tue, 29 Feb 2000 13:56:39 -0500 (EST) (envelope-from adrianp@correo.ife.org.mx) Received: (from httpd@localhost) by ife.org.mx (8.9.1/8.9.1) id MAA15944; Tue, 29 Feb 2000 12:56:22 -0600 (CST) Date: Tue, 29 Feb 2000 12:56:22 -0600 (CST) From: Adrian Perez Camarena Message-Id: <200002291856.MAA15944@ife.org.mx> X-Authentication-Warning: correo.ife.org.mx: httpd set sender to adrianp@correo.ife.org.mx using -f To: pgsql-general@postgresql.org Reply-To: adrianp@ife.org.mx MIME-Version: 1.0 Content-Type: text/plain Content-Transfer-Encoding: 8bit User-Agent: IMP/PHP3 Imap webMail Program 2.0.11 Sender: adrianp@ife.org.mx X-Originating-IP: 10.0.2.24 Subject: order by 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