pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: Indexes vs indices
3+ messages / 3 participants
[nested] [flat]

* Re: Indexes vs indices
@ 2001-04-02 16:47 Tom Lane <tgl@sss.pgh.pa.us>
  2001-04-02 16:58 ` Re: Indexes vs indices Bruce Momjian <pgman@candle.pha.pa.us>
  2001-04-02 17:20 ` Re: Re: Indexes vs indices Lamar Owen <lamar.owen@wgcr.org>
  0 siblings, 2 replies; 3+ messages in thread

From: Tom Lane @ 2001-04-02 16:47 UTC (permalink / raw)
  To: Peter Eisentraut <peter_e@gmx.net>; +Cc: Bruce Momjian <pgman@candle.pha.pa.us>; PostgreSQL-development <pgsql-hackers@postgresql.org>

[Dept of swatting flies with sledgehammers]

Peter Eisentraut <peter_e@gmx.net> 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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Indexes vs indices
  2001-04-02 16:47 Re: Indexes vs indices Tom Lane <tgl@sss.pgh.pa.us>
@ 2001-04-02 16:58 ` Bruce Momjian <pgman@candle.pha.pa.us>
  1 sibling, 0 replies; 3+ messages in thread

From: Bruce Momjian @ 2001-04-02 16:58 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Peter Eisentraut <peter_e@gmx.net>; PostgreSQL-development <pgsql-hackers@postgresql.org>

> [Dept of swatting flies with sledgehammers]
> 
> Peter Eisentraut <peter_e@gmx.net> 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:
> 

I never liked indices.  I like indexes.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Re: Indexes vs indices
  2001-04-02 16:47 Re: Indexes vs indices Tom Lane <tgl@sss.pgh.pa.us>
@ 2001-04-02 17:20 ` Lamar Owen <lamar.owen@wgcr.org>
  1 sibling, 0 replies; 3+ messages in thread

From: Lamar Owen @ 2001-04-02 17:20 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Peter Eisentraut <peter_e@gmx.net>; Bruce Momjian <pgman@candle.pha.pa.us>; PostgreSQL-development <pgsql-hackers@postgresql.org>

Tom Lane wrote:
> [Dept of swatting flies with sledgehammers]
> 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.

As a volume of the OED is about the weight of a small sledgehammer, that
fly is one dead puppy (to mix my metaphors).  Although, sense 4 is also
germane, as our index does serve to direct the query executor to the
appropriate tuples, and could be considered to be the directing
principle for performance enhancement <duck>......

But in reality, it doesn't matter.  'Indexes' is just fine.  It's
certainly a better plural than 'Vaxen' was in its time; although I am
still inclined to use 'boxen' when referring to more than one computer.

--
Lamar Owen
WGCR Internet Radio
Professor of English, Anchor Baptist Bible College --so I'm allowed to
play with the language.... :-)
1 Peter 4:11



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2001-04-02 17:20 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-04-02 16:47 Re: Indexes vs indices Tom Lane <tgl@sss.pgh.pa.us>
2001-04-02 16:58 ` Bruce Momjian <pgman@candle.pha.pa.us>
2001-04-02 17:20 ` Lamar Owen <lamar.owen@wgcr.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox