Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 06F0D9FB6FE for ; Fri, 29 Jun 2007 04:31:21 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 65064-10 for ; Fri, 29 Jun 2007 04:31:14 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sn.sai.msu.ru (sn.sai.msu.ru [195.208.220.215]) by postgresql.org (Postfix) with ESMTP id 44B419FB69A for ; Fri, 29 Jun 2007 04:31:17 -0300 (ADT) Received: from sn.sai.msu.ru (localhost [127.0.0.1]) by sn.sai.msu.ru (8.12.8/8.12.8) with ESMTP id l5T7VA3o013767; Fri, 29 Jun 2007 11:31:10 +0400 Received: from localhost (megera@localhost) by sn.sai.msu.ru (8.12.8/8.12.8/Submit) with ESMTP id l5T7V9oY013764; Fri, 29 Jun 2007 11:31:09 +0400 X-Authentication-Warning: sn.sai.msu.ru: megera owned process doing -bs Date: Fri, 29 Jun 2007 11:31:09 +0400 (MSD) From: Oleg Bartunov X-X-Sender: megera@sn.sai.msu.ru To: Andreas Joseph Krogh cc: Tom Lane , pgsql-sql@postgresql.org Subject: Re: Is index usage in LIKE-queries with UTF-8 implemented in PG-8.3 ? In-Reply-To: <200706281730.35560.andreak@officenet.no> Message-ID: References: <200706281630.16455.andreak@officenet.no> <5092.1183044056@sss.pgh.pa.us> <200706281730.35560.andreak@officenet.no> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/243 X-Sequence-Number: 28733 On Thu, 28 Jun 2007, Andreas Joseph Krogh wrote: > Anybody knows if queries of type "LIKE '%234%'" ever will be able to use > indexes, and if someone is working on it? I'm sure I'm not the only one who > would very much appreciate it:-) > This is quite easily could be done with tsearch using substring dictionary. Search archives ! Regards, Oleg _____________________________________________________________ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83