Re: Possible solution for LIKE optimization - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Possible solution for LIKE optimization
Date
Msg-id 13626.997062771@sss.pgh.pa.us
Whole thread Raw
In response to Re: Possible solution for LIKE optimization  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.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


pgsql-hackers by date:

Previous
From: Digital Wokan
Date:
Subject: Sorry about that unsubscribe
Next
From: Tom Lane
Date:
Subject: Re: partial index