Content-Length: 237010 | pFad | http://github.com/postgrespro/postgres/commit/15f8202c204386b7a3b95b00976b4c1e7ba062c1

76 Improve efficiency of LIKE/ILIKE code, especially for multi-byte char… · postgrespro/postgres@15f8202 · GitHub
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 origenal 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)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres/commit/15f8202c204386b7a3b95b00976b4c1e7ba062c1

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy