ILIKE

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

Browse pgsql-general by date

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