Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 09CDC650EC0 for ; Fri, 27 Jun 2008 11:23:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 42829-01 for ; Fri, 27 Jun 2008 11:23:08 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sn.sai.msu.ru (sn.sai.msu.ru [195.208.220.215]) by postgresql.org (Postfix) with ESMTP id B1FB5650EE5 for ; Fri, 27 Jun 2008 11:23:13 -0300 (ADT) 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 m5REMwGE013329; Fri, 27 Jun 2008 18:22:58 +0400 Received: from localhost (megera@localhost) by sn.sai.msu.ru (8.14.1/8.12.8/Submit) with ESMTP id m5REMrFb013326; Fri, 27 Jun 2008 18:22:53 +0400 X-Authentication-Warning: sn.sai.msu.ru: megera owned process doing -bs Date: Fri, 27 Jun 2008 18:22:53 +0400 (MSD) From: Oleg Bartunov X-X-Sender: megera@sn.sai.msu.ru To: Richard Huxton cc: Bruce Momjian , Marti Raudsepp , pgsql-www Subject: Re: No search results for "now" In-Reply-To: <4864937E.8050602@archonet.com> Message-ID: References: <200806262235.m5QMZT109827@momjian.us> <4864937E.8050602@archonet.com> 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.112 tagged_above=0 required=5 tests=AWL=-1.013, DNS_FROM_RFC_BOGUSMX=2.125, RCVD_IN_DNSWL_LOW=-1 X-Spam-Level: X-Archive-Number: 200806/191 X-Sequence-Number: 15418 On Fri, 27 Jun 2008, Richard Huxton wrote: > Bruce Momjian wrote: >> Marti Raudsepp wrote: >>> Hi, >>> >>> Someone pointed out in #postgresql that a search for "now" apparently >>> gives no results, even though PostgreSQL has a now() function: >>> http://search.postgresql.org/search?u=%2Fdocs%2F8.3%2Fstatic%2F&q=now >>> >>> Probably needs to be fixed. >> >> I can confirm this bug. Anyone know the cause? > > Well, "now" is a stopword in the standard english configuration. Also "and", > "or", "if", "then" but not "C". There was also problem with parser, reported several times. Looks like it's a time to redo text search configuration at postgresql.org. 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