Re: Possible solution for LIKE optimization

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Possible solution for LIKE optimization
Date: 2001-08-06 01:52:51
Message-ID: 13626.997062771@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Wait, why isn't that the solution in the first place. Let's build the
> index with an opclass that uses plain strcmp comparison.

By George, I think you've got it! All we need is comparison ops and
an opclass that use strcmp, even when USE_LOCALE is defined. Then we
document "here's how you make a LIKE-compatible index in non-ASCII
locales", and away we go.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-08-06 01:59:05 Re: partial index
Previous Message Peter Eisentraut 2001-08-06 01:45:14 Re: Possible solution for LIKE optimization