Re: how to get index scan at work?

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 />