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@Wheeler.net ICQ: 15726394
Yahoo!: dew7e
Jabber: Theory@jabber.org