X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 79AB18BA097 for ; Wed, 9 Feb 2005 05:22:28 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 30986-09 for ; Wed, 9 Feb 2005 05:22:21 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.194]) by svr1.postgresql.org (Postfix) with ESMTP id 955EF8BA069 for ; Wed, 9 Feb 2005 05:22:20 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 71so1223565wra for ; Tue, 08 Feb 2005 21:22:20 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=hYPNIEug3K4BoxHRAhy6O2Vcqh1bsCHap31kXIMnpKC32iMeXYMX8m0CEM0JePZ04kqzxv/xBZJB/umGVGYnLvlkOXWkFn+yolJrRA+ABkb43hdVXQsKQGO5W2+WUA79MVqhfc6ww8WFcPmnouFJa4bykw1i8gTfueq4zjvyoRE= Received: by 10.54.51.44 with SMTP id y44mr224015wry; Tue, 08 Feb 2005 21:21:56 -0800 (PST) Received: by 10.54.31.32 with HTTP; Tue, 8 Feb 2005 21:21:56 -0800 (PST) Message-ID: <2989532e050208212110871eff@mail.gmail.com> Date: Wed, 9 Feb 2005 10:51:56 +0530 From: Antony Paul Reply-To: Antony Paul To: pgsql-sql@postgresql.org Subject: Can tsearch replace ilike queries ? Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.543 tagged_above=0 required=5 tests=AWL, FROM_ENDS_IN_NUMS, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200502/109 X-Sequence-Number: 20220 Hi all, I read in another thread about using tsearch for ilike queries. My question is can it rprovide the full ilike functionality with a better performance than ilike ?. rgds Antony Paul