Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 1AF329FB285 for ; Tue, 6 Mar 2007 17:49:20 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 72960-10 for ; Tue, 6 Mar 2007 17:49:14 -0400 (AST) X-Greylist: delayed 00:07:43.060851 by SQLgrey-1.7.4 Received: from fmed.uba.ar (mail.fmed.uba.ar [157.92.152.1]) by postgresql.org (Postfix) with ESMTP id 9E0FF9FB2FB for ; Tue, 6 Mar 2007 17:49:14 -0400 (AST) Received: from [157.92.155.58] (unknown [157.92.155.58]) by fmed.uba.ar (Postfix) with ESMTP id B609B4C19FF for ; Tue, 6 Mar 2007 18:52:22 -0300 (ART) Message-ID: <45EDDE5F.2030303@fmed.uba.ar> Date: Tue, 06 Mar 2007 18:34:23 -0300 From: Gerardo Herzig User-Agent: Mozilla Thunderbird 1.0.7 (X11/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: best index for ~ ordering? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/62 X-Sequence-Number: 27700 Hi all, i have a large table with one varchar field, and im triyng to get information about what index should i use in order to using that index (if this is possible) for ~ searching, and/or using LIKE searching. Thanks! Gerardo