Thread: Functional Indexes

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

Hi people;

I'm not sure my question is in topic, and if it's not please don't
reply that mail on the list.

What's the best way to use indexes (indices ?) with Pg ?
Is it possible to have simple examples showing when it's interesting
to create an index, and when it's not ? Are there some particular
things to know regarding the way Pg works with indexes ?

Thanks.
Fabrice Scemama