Functional Indexes

From: "Bryan White" <bryan(at)arcamax(dot)com>
To: "PgSQL-sql" <pgsql-sql(at)postgreSQL(dot)org>
Subject: Functional Indexes
Date: 1999-02-05 22:54:05
Message-ID: 017801be515a$6e964180$a3f0f6ce@bryan.arcamax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Sascha Schumann 1999-02-06 12:49:34 Re: [SQL] index on aggregate function
Previous Message Tim Perdue, The Des Moines City.net 1999-02-05 22:33:05 Re: Performance Question