Re: how to get index scan at work? - Mailing list pgsql-sql

On Fri, 19 Apr 2002, Rajesh Kumar Mallah wrote:

> btw i could not create the index the way you suggested
>
> regds
>
> tradein_clients=> CREATE UNIQUE  INDEX  email_bank_case_insen on
> LOWER(email_bank(email));
> ERROR:  DefineIndex: relation "lower" not found
> tradein_clients=>

It actually should be:
create index email_bank_case_insen on email_bank(lower(email));

And that should allow
lower(email)='<string>'
to be indexable.