ILIKE

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: ILIKE
Date: 2003-02-22 00:36:43
Message-ID: Pine.LNX.4.44.0302220134210.2067-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

AFAICT, ILIKE cannot use an index. So why does ILIKE even exist, when
lower(expr) LIKE 'foo' provides a solution that can use an index and is
more standard, too?

--
Peter Eisentraut peter_e(at)gmx(dot)net

Responses

  • Re: ILIKE at 2003-02-22 15:56:00 from mlw
  • Re: ILIKE at 2003-02-24 16:34:14 from scott.marlowe
  • Re: ILIKE at 2003-02-25 13:13:27 from mlw

Browse pgsql-hackers by date

  From Date Subject
Next Message Ross J. Reedstrom 2003-02-22 02:39:12 Re: Simplifying timezone support
Previous Message Ross J. Reedstrom 2003-02-21 23:45:54 Re: Simplifying timezone support