Functional Indexes - Mailing list pgsql-sql

From Bryan White
Subject Functional Indexes
Date
Msg-id 017801be515a$6e964180$a3f0f6ce@bryan.arcamax.com
Whole thread Raw
List 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


pgsql-sql by date:

Previous
From: "Tim Perdue, The Des Moines City.net"
Date:
Subject: Re: Performance Question
Next
From: Sascha Schumann
Date:
Subject: Re: [SQL] index on aggregate function