Re: ILIKE

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

Peter,

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

And how is ~* indexable?

--
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

  • Re: ILIKE at 2003-02-24 19:19:34 from Peter Eisentraut

Browse pgsql-hackers by date

  From Date Subject
Next Message Darko Prenosil 2003-02-24 19:53:05 I cant find it or I'm just lazy ?
Previous Message Peter Eisentraut 2003-02-24 19:19:34 Re: ILIKE