X-Original-To: pgsql-php@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 152D3474E42 for ; Thu, 27 Feb 2003 05:56:02 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 87579-09 for ; Thu, 27 Feb 2003 05:55:51 -0500 (EST) Received: from jive.SoftHome.net (jive.SoftHome.net [66.54.152.27]) by postgresql.org (Postfix) with SMTP id 5E79D475A09 for ; Thu, 27 Feb 2003 05:52:39 -0500 (EST) Received: (qmail 1018 invoked by uid 417); 27 Feb 2003 10:52:41 -0000 Received: from shunt-smtp-out-0 (HELO softhome.net) (172.16.3.12) by shunt-smtp-out-0 with SMTP; 27 Feb 2003 10:52:41 -0000 Received: from supercable ([217.216.221.248]) (AUTH: LOGIN adriantineo@softhome.net) by softhome.net with esmtp; Thu, 27 Feb 2003 03:52:17 -0700 Message-ID: <001601c2de4e$a0176ba0$f8ddd8d9@supercable.es> From: "Adrian Tineo" To: pgsql-php@postgresql.org References: <31EA81C61A3D014F8D6933864F32C604059151@server1.fusion-advertising.co.uk> Subject: Re: ORDER BY question Date: Thu, 27 Feb 2003 11:54:06 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/57 X-Sequence-Number: 1908 >Is there any way to do a case insensitive sort?. Try: SELECT colum_name FROM table_name ORDER BY upper(colum_name); For a list of support functios like upper() check this url: http://www.postgresql.org/docs/aw_pgsql_book/node92.html _________ Adrian Tineo