"Markus" <markus(dot)herven(at)outpost24(dot)com> writes:
> select 'ba' ilike '%__%';
> return true as expected in 8.2 but false in 8.4.
I have a feeling that this represents still another bug in the
special-case path for % followed by _ (cf bug #4821). If so,
maybe we ought to just toss out that optimization?
regards, tom lane