X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 73677D1B55F for ; Wed, 22 Oct 2003 20:25:16 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 81811-08 for ; Wed, 22 Oct 2003 17:24:47 -0300 (ADT) Received: from davinci.ethosmedia.com (unknown [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id 06E5ED1B55C for ; Wed, 22 Oct 2003 17:24:45 -0300 (ADT) Received: from [66.219.92.2] (HELO temoku) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3807695; Wed, 22 Oct 2003 13:25:19 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: Tom Lane Subject: Re: Expressional Indexes Date: Wed, 22 Oct 2003 13:22:26 -0700 User-Agent: KMail/1.4.3 Cc: pgsql-sql@postgresql.org References: <7141E2A2-04BE-11D8-81AE-0005029FC1A7@myrealbox.com> <200310221239.58302.josh@agliodbs.com> <18349.1066851898@sss.pgh.pa.us> In-Reply-To: <18349.1066851898@sss.pgh.pa.us> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200310221322.26013.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/291 X-Sequence-Number: 15691 Tom, > Mainly that "expressional" is a made-up word. So? We're in the tech biz, Tom. New-coined words are expected. And tha= t=20 way nobody will expect it to mean something else, since we made it up.=20 -- H. Dumpty, Q.E.D. > I have been considering using "calculated index" or "computed index" > but dunno if that really conveys anything. Well, "Expression Indexes" is the most accurate. Or "Expression-Based=20 Indexes." --=20 -Josh Berkus Aglio Database Solutions San Francisco