Re: ILIKE

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ILIKE
Date: 2003-02-24 19:19:34
Message-ID: Pine.LNX.4.44.0302242018390.2108-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Josh Berkus writes:

> 4) It's just as indexible (or not indexable) as regexp comparisons, and easier
> to understand for users from the Microsoft world than regexp.

ILIKE is not indexible at all. Other forms of pattern comparisons are at
least indexible sometimes.

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

In response to

  • Re: ILIKE at 2003-02-24 18:39:15 from Josh Berkus

Responses

  • Re: ILIKE at 2003-02-24 19:22:08 from Josh Berkus
  • Re: ILIKE at 2003-02-24 21:25:51 from Tom Lane

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2003-02-24 19:22:08 Re: ILIKE
Previous Message Peter Eisentraut 2003-02-24 19:16:44 Possibly inconsistent type casting logic