Received: from arcamax.com (arcamax.com [206.246.240.138])
	by hub.org (8.9.2/8.9.1) with ESMTP id RAA96803
	for <pgsql-sql@postgreSQL.org>; Fri, 5 Feb 1999 17:54:11 -0500 (EST)
	(envelope-from bryan@arcamax.com)
Received: from bryan.arcamax.com (bryan [206.246.240.163])
	by arcamax.com (8.8.7/8.8.7) with SMTP id RAA11660
	for <pgsql-sql@postgreSQL.org>; Fri, 5 Feb 1999 17:54:06 -0500
Message-ID: <017801be515a$6e964180$a3f0f6ce@bryan.arcamax.com>
From: "Bryan White" <bryan@arcamax.com>
To: "PgSQL-sql" <pgsql-sql@postgreSQL.org>
Subject: Functional Indexes
Date: Fri, 5 Feb 1999 17:54:05 -0500
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3

The documentation for CREATE INDEX implies that functions are allowed in
index definitions but when I execute:

create unique index idxtest on customer (lower(email));

the result is:

ERROR:  DefineIndex: (null) class not found

Should this work?  Do I have the syntax wrong?

Bryan White
ArcaMax Inc.
Yorktown VA
www.arcamax.com