pgsql: Teach pattern_fixed_prefix() about collations.
pgsql: Teach pattern_fixed_prefix() about collations.
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Teach pattern_fixed_prefix() about collations. This is necessary, not optional, now that ILIKE and regexes are collation aware --- else we might derive a wrong comparison constant for index optimized pattern matches. Branch ------ master Details ------- http://git.postgresql.org/pg/commitdiff/3c381a55b0fa1c4ca328211e39df8e1a715129cb Modified Files -------------- src/backend/optimizer/path/indxpath.c | 34 +++++---- src/backend/utils/adt/selfuncs.c | 137 +++++++++++++++++++++++---------- src/include/utils/selfuncs.h | 1 + 3 files changed, 117 insertions(+), 55 deletions(-)