Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 8093F1335B36 for ; Tue, 30 Nov 2010 13:56:00 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 12248-04 for ; Tue, 30 Nov 2010 17:55:53 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gmx.net (mailout-de.gmx.net [213.165.64.23]) by mail.postgresql.org (Postfix) with SMTP id 7DA4B133655C for ; Tue, 30 Nov 2010 13:55:51 -0400 (AST) Received: (qmail invoked by alias); 30 Nov 2010 17:55:50 -0000 Received: from a88-115-218-165.elisa-laajakaista.fi (EHLO [10.0.0.101]) [88.115.218.165] by mail.gmx.net (mp035) with SMTP; 30 Nov 2010 18:55:50 +0100 X-Authenticated: #495269 X-Provags-ID: V01U2FsdGVkX1+GFstqPYeGyv+nvx55s0aR4Jcram+1Duul7zYTa1 UgS5QJBsL3rj3N Subject: Re: [COMMITTERS] pgsql: Add index entries for more functions From: Peter Eisentraut To: Thom Brown Cc: pgsql-docs@postgresql.org In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Date: Tue, 30 Nov 2010 19:55:48 +0200 Message-ID: <1291139748.13957.6.camel@vanquo.pezone.net> Mime-Version: 1.0 X-Mailer: Evolution 2.30.3 Content-Transfer-Encoding: 8bit X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201011/37 X-Sequence-Number: 6235 On sön, 2010-11-28 at 23:59 +0000, Thom Brown wrote: > Whilst looking at the latest build of the docs at > http://developer.postgresql.org/pgdocs/postgres/bookindex.html I've > noticed a discrepancy in this commit from the patch I provided. I > specified "average" as a primary term with "avg" as a secondary term, > but the commit shows them both as separate primary entries. Was this > changed intentionally? Yes. I have no written reference for this, but from experience, my understanding of the way index entries should work is that the primary term is something you would look up, and the secondary term is something you would look up among the primary terms. So I think a reader would probably look up both "avg" because that's the function he's using, and "average" because that's the term for what he's trying to do. Somewhat made up examples of what reasonable secondary terms might be: avg, for user-defined types performance of