Re: like and optimization - Mailing list pgsql-hackers

From Tom Lane
Subject Re: like and optimization
Date
Msg-id 5704.980036577@sss.pgh.pa.us
Whole thread Raw
In response to like and optimization  (Juriy Goloveshkin <juriy@avias.com>)
List pgsql-hackers
Juriy Goloveshkin <juriy@avias.com> writes:
> Hello, I didn't know pgsql-sources close,
> so I wrote this code just as example of idea.
> Can somebody review and make patch for pgsql?

AFAICT this only deals with the issue of single-byte characters that
sort in an order different from their numeric order.  The existing
make_greater_string() code already deals with that case.  Where it
falls down is cases where sorting is context-dependent (multi-pass
sort rules, digraphs, things like that).  But I don't see anything
here that would make such cases work.

If you're trying to tell us that the 7.0.* code works correctly for
KOI8-R locale, we'd be glad to re-enable LIKE optimization for that
locale ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Ian Lance Taylor
Date:
Subject: Re: AW: AW: AW: Re: tinterval - operator problems on AIX
Next
From: Tom Lane
Date:
Subject: Re: C++ interface build on FreeBSD 4.2 broken?