From: | David Wheeler <David(at)Wheeler(dot)net> |
---|---|
To: | PostgreSQL-general <pgsql-general(at)postgresql(dot)org> |
Subject: | ILIKE |
Date: | 2001-08-23 22:23:22 |
Message-ID: | Pine.LNX.4.33.0108231520390.10006-100000@theory.versive.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hey All,
Just noticed the new ILIKE variant on the LIKE operator. Tell me, does
this operator use indexes (the FAQ isn't clear on that).
Currently, I've got a functional index
CREATE INDEX tabindex on tab (lower(col));
Where I want to look in CHAR/VARCHAR/TEXT fields, and always compare
against a lowercase string so that I use that index. But if ILIKE can do
it without all the functional indexing, so much the better, eh?
Thanks,
David
--
David Wheeler AIM: dwTheory
David(at)Wheeler(dot)net ICQ: 15726394
Yahoo!: dew7e
Jabber: Theory(at)jabber(dot)org
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Arnold | 2001-08-23 23:32:03 | Re: problems transfering databases |
Previous Message | Lee Harr | 2001-08-23 21:46:04 | Re: Help Problem mysql ???? |