Skip to content

Commit 15f8202

Browse files
adunstanadunstan
committed
Improve efficiency of LIKE/ILIKE code, especially for multi-byte charsets,
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.
1 parent 964ec46 commit 15f8202

File tree

2 files changed

+183
-439
lines changed

2 files changed

+183
-439
lines changed

0 commit comments

Comments
 (0)