On 8/14/13, Kevin Grittner <kgrittn@ymail.com> wrote:
> Robert James <srobertjames@gmail.com> wrote:
>
>> I'm confused: What's the difference between
>> col LIKE 'foo%'
>> and
>> col LIKE f1 || '%'
>> ?
>
> The planner knows that 'foo%' doesn't start with a wildcard.
>
>> Either way, it's anchored to the beginning of the string.
>
> Not necessarily.
I see, yes, f1 might include a wildcard.
Is there a way to escape f1 so that wildcards aren't interpreted?
That's anyway the behavior I need, of course. And will that help the
planner?
What type of index will help the planner here?