X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 8B89E475E1F for ; Sat, 22 Feb 2003 06:28:06 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 51140-02 for ; Sat, 22 Feb 2003 06:27:37 -0500 (EST) Received: from smtp-26.ig.com.br (smtp-26.ig.com.br [200.226.132.160]) by postgresql.org (Postfix) with SMTP id 8946B475A6D for ; Sat, 22 Feb 2003 06:01:20 -0500 (EST) Received: (qmail 4265 invoked from network); 22 Feb 2003 11:01:25 -0000 Received: from shasta206060.ig.com.br (HELO ignis) (200.151.206.60) by smtp-26.ig.com.br with SMTP; 22 Feb 2003 11:01:25 -0000 From: "Edipo E. F. Melo" To: "pgsql-sql" Date: Sat, 22 Feb 2003 08:01:54 -0300 Reply-To: "Edipo E. F. Melo" X-Mailer: PMMail 2000 Professional (2.20.2360) For Windows 98 (4.10.2222) MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Subject: SORT with accents Message-Id: <20030222110120.8946B475A6D@postgresql.org> Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/637 X-Sequence-Number: 12035 Hello friends, How do I sort names to ignore accents. In other words, a result like thi= s: a, =E1 (a acute), b, c, d, e,=20 =E9 (e acute), ... Thanks a lot! []'s Edipo Elder F. de Melo [edipoelder@ig.com.br] [ ICQ#: 4546070 ]