Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id AEDA79FB2B1 for ; Wed, 21 Mar 2007 06:46:41 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 90002-05 for ; Wed, 21 Mar 2007 06:46:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from svr2.hagander.net (svr2.hagander.net [88.198.128.226]) by postgresql.org (Postfix) with ESMTP id 88FF39FA5DD for ; Wed, 21 Mar 2007 06:46:38 -0300 (ADT) Received: by svr2.hagander.net (Postfix, from userid 1000) id 5ACD2DCC712; Wed, 21 Mar 2007 10:46:37 +0100 (CET) Date: Wed, 21 Mar 2007 10:46:37 +0100 From: Magnus Hagander To: nikolay@samokhvalov.com Cc: pgsql-www@postgresql.org Subject: Re: Search on postgresql.org doesn't work properly? Message-ID: <20070321094637.GG30013@svr2.hagander.net> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.11 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.005 tagged_above=0 required=5 tests=AWL, BAYES_50 X-Spam-Level: X-Archive-Number: 200703/46 X-Sequence-Number: 11743 On Tue, Mar 20, 2007 at 05:03:40PM +0300, Nikolay Samokhvalov wrote: > Trying to search for "INHERITS" I see empty result: > http://search.postgresql.org/search?u=%2Fdocs%2F8.2%2Finteractive%2F&q=INHERITS > > "Your search for INHERITS returned no hits." Thanks for reporting this, fixed. It was a case of double-escaping the suburl, so it actually search in '/docs instead of /docs. (The problem was in the suburl search, not in the word inherits itself) > But if I check "Include community sites" checkbox, I get 467 links: > http://search.postgresql.org/search?u=%2Fdocs%2F8.2%2Finteractive%2F&q=INHERITS&a=1 Including community sites negates the url restriction, that's why. > Why so? The first link found is > http://www.postgresql.org/docs/8.1/interactive/ddl-partitioning.html. > Why the main documentation is included to search results only when > "Include community sites" is selected? Because it searches main docs *plus* community sites. Thus, "include". Otherwise we'd have a completely different selection in the menu on the left. > Also, a couple of additional notes: > 1. I would add DISTINCT to search SELECT (in the example above > results 2-5 are the same, > http://www.postgresql.org/docs/current/interactive/ddl-partitioning.html). They're not distinct, they're from different versions. > 2. > I'd also add ordering rule to push most recent version of > documentation up (in the same example we see that #1 is docs for v8.1, > and only after that -- the same page for v8.2). Yeah, that's on my TODO list. //Magnus