• Andrew Dunstan's avatar
    Improve efficiency of LIKE/ILIKE code, especially for multi-byte charsets, · 15f8202c
    Andrew Dunstan authored
    and most especially for UTF8. Remove unnecessary special cases for bytea
    processing and single-byte charset ILIKE.  a ILIKE b is now processed as
    lower(a) LIKE lower(b) in all cases. The code is now considerably simpler. All
    comparisons are now performed byte-wise, and the text and pattern are also
    advanced byte-wise where it is safe to do so - essentially where a wildcard is
    not being matched.
    Andrew Dunstan, from an original patch by ITAGAKI Takahiro, with ideas from
    Tom Lane and Mark Mielke.
    15f8202c
like.c 8.03 KB