Re: LIKE foo% optimization easily defeated by OR?

Greg Stark <stark@mit.edu> writes:
> On 3 January 2018 at 22:34, Alexander Korotkov
> <a.korotkov@postgrespro.ru> wrote:
>> I've checked similar case on database with PostgreSQL mailing lists.  It
>> works for me.

> Wow that's fascinating. I wonder why it's not kicking in for me.

text vs varchar maybe?

            regards, tom lane