Hi Thomas, <p>it did not work for me! <p><tt><font color="#000099">tradein_clients=> explain SELECT email_id
fromemail_bank where email ILIKE 'mallah@grex.org';</font></tt><br /><tt><font color="#000099">NOTICE: QUERY
PLAN:</font></tt><br/><tt><font color="#000099">Seq Scan on email_bank (cost=0.00..22926.16 rows=1
width=4)</font></tt><br/><tt><font color="#000099">EXPLAIN</font></tt><br /><tt><font
color="#000099">tradein_clients=>explain SELECT email_id from email_bank where email =
'mallah@grex.org';</font></tt><br/><tt><font color="#000099">NOTICE: QUERY PLAN:</font></tt><br /><tt><font
color="#000099">IndexScan using email_bank_case_insen on email_bank (cost=0.00..4.83 rows=1 width=4)</font></tt><br
/><tt><fontcolor="#000099">EXPLAIN</font></tt><br /><tt><font color="#000099">tradein_clients=></font></tt><br />
<p>btwi could not create the index the way you suggested <p>regds <p><tt>tradein_clients=> CREATE UNIQUE INDEX
email_bank_case_insenon LOWER(email_bank(email));</tt><br /><b><tt><font color="#CC0000">ERROR: DefineIndex: relation
"lower"not found</font></tt></b><br /><tt>tradein_clients=></tt><br />