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