Re: [HACKERS] Possible solution for LIKE optimization

[Tom Lane]

Peter Eisentraut <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html