From: | Rajesh Kumar Mallah <mallah(at)trade-india(dot)com> |
---|---|
To: | Thomas Swan <tswan(at)olemiss(dot)edu> |
Cc: | PostgResql SQL Mailing List <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: how to get index scan at work? |
Date: | 2002-04-19 16:33:24 |
Message-ID: | 3CC046D4.B7F972A7@trade-india.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi Thomas,
it did not work for me!
tradein_clients=> explain SELECT email_id from email_bank where email
ILIKE 'mallah(at)grex(dot)org';
NOTICE: QUERY PLAN:
Seq Scan on email_bank (cost=0.00..22926.16 rows=1 width=4)
EXPLAIN
tradein_clients=> explain SELECT email_id from email_bank where email =
'mallah(at)grex(dot)org';
NOTICE: QUERY PLAN:
Index Scan using email_bank_case_insen on email_bank (cost=0.00..4.83
rows=1 width=4)
EXPLAIN
tradein_clients=>
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=>
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2002-04-19 17:12:04 | Re: how to get index scan at work? |
Previous Message | Stéphane DEWITTE | 2002-04-19 14:39:43 | How to log outputs from pl/pgsql into a file ? |