X-Original-To: pgsql-novice-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id C1C19D1B54C
	for <pgsql-novice-postgresql.org@localhost.postgresql.org>;
	Wed, 22 Oct 2003 19:23:28 +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 75454-05
	for <pgsql-novice-postgresql.org@localhost.postgresql.org>;
	Wed, 22 Oct 2003 16:22:59 -0300 (ADT)
Received: from davinci.ethosmedia.com (unknown [209.128.84.228])
	by svr1.postgresql.org (Postfix) with ESMTP id B2755D1B525
	for <pgsql-novice@postgresql.org>; Wed, 22 Oct 2003 16:22:57 -0300 (ADT)
Received: from [66.219.92.2] (HELO temoku)
	by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2)
	with ESMTP id 3807415; Wed, 22 Oct 2003 12:23:37 -0700
Content-Type: text/plain;
  charset="iso-8859-1"
From: Josh Berkus <josh@agliodbs.com>
Reply-To: josh@agliodbs.com
Organization: Aglio Database Solutions
To: Michael Glaesmann <grzm@myrealbox.com>,
	pgsql-novice@postgresql.org
Subject: Re: Functional index problems. (Was: Many joins: monthly summaries
	S-L--O--W)
Date: Wed, 22 Oct 2003 12:20:44 -0700
User-Agent: KMail/1.4.3
References: <7141E2A2-04BE-11D8-81AE-0005029FC1A7@myrealbox.com>
In-Reply-To: <7141E2A2-04BE-11D8-81AE-0005029FC1A7@myrealbox.com>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200310221220.44856.josh@agliodbs.com>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200310/189
X-Sequence-Number: 8626

Michael,

> <http://developer.postgresql.org/docs/postgres/sql-createindex.html>=20
> The 7.3.2 documents I have say that there cannot be multicolumn=20
> functional indexes, though there's no mention of this in the new=20
> documentation. Does this mean this proscription has been lifted?

Yes.

--=20
-Josh Berkus
 Aglio Database Solutions
 San Francisco