Received: from sss.pgh.pa.us ([216.151.103.158]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f32GoPK12805 for ; Mon, 2 Apr 2001 12:50:25 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f32Gltw08185; Mon, 2 Apr 2001 12:47:55 -0400 (EDT) To: Peter Eisentraut cc: Bruce Momjian , PostgreSQL-development Subject: Re: Indexes vs indices In-reply-to: References: Comments: In-reply-to Peter Eisentraut message dated "Mon, 02 Apr 2001 17:15:36 +0200" Date: Mon, 02 Apr 2001 12:47:55 -0400 Message-ID: <8182.986230075@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200104/28 X-Sequence-Number: 6988 [Dept of swatting flies with sledgehammers] Peter Eisentraut writes: > One of these days we should decide on a spelling of "indexes" vs > "indices". I'd vote for "indexes", first on the practical grounds that it's a more sensible spelling, and secondly on the grounds that the Oxford English Dictionary agrees. Its entry for the noun index has: Index: PL indexes and indices. In current use the plural is indices in senses 8, 9, and usually in other senses except 5, in which indexes is usual. 1. The fore-finger. (Now chiefly Anat.) 2. A piece of wood, metal, or the like which serves as a pointer. 3. The hand of a clock, watch, or sundial. (Now rare) 4. That which serves to direct ... a guiding principle. 5. (a) A table of contents, preface, or prologue (Obs). (b) An alphabetical list, placed (usually) at the end of a book, of the names, subjects, etc. occurring in it, with indication of the places in which they occur. 6. Spec. (short for Index librorum prohibitorum) The list of books which Roman Catholics are forbidden to read. 7. A "hand" marker in printing. (Obs) 8. Math. (a) a number placed above and to the right of another quantity to denote a power or root. (b) the integral part of a logarithm. (Obs) 9. In various sciences, a number or formula expressing some property of the thing in question. (ex. Index of refraction) (I've abbreviated the definitions other than sense 5b.) I'd say that the use of "index" in database work clearly falls under sense 5b, and so "indexes" is the usual plural according to the OED. The habit of using "indices" in the Postgres documentation seems to go back to the Berkeley days. Possibly the Berkeley boys were familiar with sense 8 and/or 9 and so tended to use that plural. regards, tom lane