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
Message-ID: <017801be515a$6e964180$a3f0f6ce@bryan.arcamax.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bryan@arcamax.com
Subject: Re: Functional Indexes
In-Reply-To: <017801be515a$6e964180$a3f0f6ce@bryan.arcamax.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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