X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 26370475AFF for ; Wed, 19 Feb 2003 16:12:24 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 53352-10 for ; Wed, 19 Feb 2003 16:12:13 -0500 (EST) Received: from quasar.skima.is (quasar.skima.is [212.30.200.205]) by postgresql.org (Postfix) with ESMTP id 8AE54475D0D for ; Wed, 19 Feb 2003 15:53:31 -0500 (EST) Received: from maradona.totw.org ([157.157.150.135] [157.157.150.135]) by quasar.skima.is with ESMTP; Wed, 19 Feb 2003 20:53:32 Z Message-Id: <5.1.0.14.0.20030219205147.026fa098@localhost> X-Sender: joi/postur.betra.is@localhost (Unverified) X-Mailer: QUALCOMM Windows Eudora Version 5.1 Date: Wed, 19 Feb 2003 20:53:21 +0000 To: pgsql-sql@postgresql.org From: JBJ Subject: Re: once again, sorting with Unicode In-Reply-To: <200302192016.h1JKGSEU014871@tksoft.com> References: <11412.1045668157@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/440 X-Sequence-Number: 11838 At 20:16 19.2.2003, Troy K wrote: >You can generate indexes for your custom functions, though, >which will speed things up. This is what I've done, successfully. Sounds useful, do you have a demo of such a function? I can if all else fails sort the data using PHP but am not too fond of it when I have over 2000 rows or more as will be the case in other tables. Thanks all for the answers.