Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 68DAC2E0083 for ; Thu, 28 Feb 2008 04:54:44 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 12875-04 for ; Thu, 28 Feb 2008 04:54:38 -0400 (AST) 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 C7CB32E007F for ; Thu, 28 Feb 2008 04:54:37 -0400 (AST) Received: from sn.sai.msu.ru (localhost [127.0.0.1]) by sn.sai.msu.ru (8.14.1/8.12.8) with ESMTP id m1S8sYhg031306; Thu, 28 Feb 2008 11:54:34 +0300 Received: from localhost (megera@localhost) by sn.sai.msu.ru (8.14.1/8.12.8/Submit) with ESMTP id m1S8sYAB031303; Thu, 28 Feb 2008 11:54:34 +0300 X-Authentication-Warning: sn.sai.msu.ru: megera owned process doing -bs Date: Thu, 28 Feb 2008 11:54:34 +0300 (MSK) From: Oleg Bartunov X-X-Sender: megera@sn.sai.msu.ru To: Gevik Babakhani cc: "'Magnus Hagander'" , "'PostgreSQL - WWW ML'" Subject: Re: www search behaviour In-Reply-To: <003f01c879e6$8ecdf380$0a01a8c0@gevmus> Message-ID: References: <004a01c879a3$874b7a80$0a01a8c0@gevmus> <20080228082525.GD13189@svr2.hagander.net> <003f01c879e6$8ecdf380$0a01a8c0@gevmus> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.591 tagged_above=0 required=5 tests=AWL=-1.534, DNS_FROM_RFC_BOGUSMX=2.125 X-Spam-Level: X-Archive-Number: 200802/237 X-Sequence-Number: 14106 On Thu, 28 Feb 2008, Gevik Babakhani wrote: >> Yeah, it's climbing up my TODO list... > > Anything that I can do to help? Several variants: 1. Create custom parser for pgweb, which doesn't mean that '_' is a separator 2. Create synonym dictionary for pgweb, which lists all pg specific terms 1. is a most right way, 2. is a most easy way, just create word stats, see all terms with '_' and create pgvars dictionary like some_word some_word Then created text search configuration , test it and give it to Magnus. btw, Magnus, did you move to 8.3 ? 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